Think of it this way. When someone says they have a meeting from 1-2 and
another from 2-3, do those meetings overlap? They do not, because we're
actually saying the first meeting is from 1:00 through 1:59:59.9. The
Postgres date ranges are the same way. The starting point is inclusive,
bu
On Tue, Sep 14, 2021 at 1:54 PM Raymond Brinzer
wrote:
>
> So, the affection I have for SQL is due to it being a gateway to a
> great idea; my frustration is that it's a bottleneck in getting to
> that same idea.
>
>
I have the opposite perspective. As a dev/manager, SQL is much more
powerful at
On Thu, Apr 1, 2021 at 11:06 AM Glen Huang wrote:
> Care to expand why they are tricker? I presume they run the risk of being
> referenced more than once?
>
There are lots of gotchas. It's also been a few years since I dug deep into
this, so some of this may have changed in more recent versions.
On Thu, Apr 1, 2021 at 10:49 AM Glen Huang wrote:
> If I decide to replace all my transaction code with CTE, will I shoot
> myself in the foot down the road?
>
I do this all the time and makes code way cleaner. It's very
straightforward with inserts queries. When you deal with updates/deletes
On Fri, Sep 11, 2020 at 1:31 PM Harmen wrote:
> Hi all,
>
> Are there any known problems with this strategy? Are they any other
> methods of
> inserting lots of records in a nicer way?
>
I do this all the time with insert and it's wonderful. It can get tricky
if you need to do UPDATEs.
You can
One aspect is if there is no one listening when a notify happens, the
message is lost (e.g. no durability). If this is important to you, it can
be addressed by writing the messages to a table as well when you NOTIFY,
and the listener deletes messages after they are processed. On connection
the l
You can use COPY over DBI.
https://metacpan.org/pod/DBD::Pg#COPY-support
On Fri, Jan 31, 2020 at 2:03 PM Pavel Stehule
wrote:
>
>
> pá 31. 1. 2020 v 19:25 odesílatel Matthias Apitz
> napsal:
>
>>
>> Hello,
>>
>> Since ages, we transfer data between different DBS (Informix, Sybase,
>> Oracle, a
On Wed, Nov 20, 2019 at 9:16 AM stan wrote:
>
> How can i make these "invisible" characters visible?
>
>
>
In psql, by default it displays nulls as nothing. You can specify what
they should display as with:
\pset null ''
Chances are those are all nulls, and will now display as whatever you set
On Fri, Jul 20, 2018 at 4:27 AM wrote:
>
> b) can a sql function return the count of affected rows of some query?
> create function merge_names(int, int) returns void as
> $_$
> update namelinks set nid = $2 where nid = $1;
> -- want the affected rows of the above query
> delete from names where
f target_point exists
RELEASE
=# rollback to target_point; <----- rollback to it
ROLLBACK
Cheers,
-Brian Dunavant
10 matches
Mail list logo
