Is there a built-in way to look for NULL array elements? I was
thinking of something like NULL IS DISTINCT FROM ALL (array expression)
but that doesn't work:
test=> SELECT NULL IS DISTINCT FROM ALL (ARRAY[1, 2, 3]);
ERROR: syntax error at or near "ALL" at character 30
LINE 1: SELECT NULL IS DIST
Simon Riggs <[EMAIL PROTECTED]> writes:
> COPY FROM can read in sufficient rows until it has a whole block worth
> of data, then get a new block and write it all with one pair of
> BufferLock calls.
> Comments?
I don't see any way to do this without horrible modularity violations.
The COPY code h
Since we just discussed using a multi-row per buffer lock technique with
Seq Scans, it seems appropriate to discuss a similar technique with COPY
FROM that I had been mulling over.
COPY FROM can read in sufficient rows until it has a whole block worth
of data, then get a new block and write it all
On Sun, Nov 27, 2005 at 08:45:18AM -0700, Michael Fuhr wrote:
> Looks like the value is stuck at 2^31 - 1 seconds:
I see this behavior back to at least 7.3. I'd guess it's because
strtol() indicates overflow by returning LONG_MAX and setting errno
to ERANGE, but the code doesn't check for that.
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Is Wez of the PHP project correct here in that you can't find parameter
> types of statements via libpq?
Per the description of PQprepare:
: At present, there is no way to determine the actual data type inferred
: for any parameters whose typ
Volkan YAZICI <[EMAIL PROTECTED]> writes:
> Here's my proposal without breaking the current implementation:
> [18: ] name + '\0' + lowercased_name
Forget it --- this is proposing a protocol breakage in order to deal
with libpq's internal mistake. It does not address the problem either;
which str
Magnus Hagander wrote:
For pgadmin, one hint said "is the 8th July" instead of "8th of July"
You'll have to talk to the pgadmin guys about that.
Yup, teach 'em correct English :-)
Fixed in svn.
Regards,
Andreas
---(end of broadcast)---
TIP
On Sun, Nov 27, 2005 at 11:15:04PM +0800, Christopher Kings-Lynne wrote:
> What's going on here? Some sort of integer wraparound?
[...]
> test=# select interval '2378234234 seconds';
>interval
> --
> 596523:14:07
> (1 row)
Looks like the value is stuck at 2^31 - 1 seconds:
test=
What's going on here? Some sort of integer wraparound?
WORKS
=
mysql=# select interval '2378 seconds';
interval
--
00:39:38
(1 row)
mysql=#
mysql=# select 2378 * interval '1 second';
?column?
--
00:39:38
(1 row)
DOESN'T WORK
test=# select interval '237823
Is Wez of the PHP project correct here in that you can't find parameter
types of statements via libpq?
Chris
Original Message
Subject: [PHP-CVS] cvs: php-src(PHP_5_1) /ext/pdo_pgsql package.xml
pgsql_driver.c pgsql_statement.c php_pdo_pgsql_int.h
Date: Fri, 25 Nov 2005 03:35
If you don't give a password, the randomly generated one is ghastly. Not
sure if this is a Windows thing or what, but it was definitely a strong
password. Impossible to remember, and very difficult to write down and enter.
It's not necessary to remember that password...
> Not sure if this is the right place, but win32-hackers seems
> to be dead.
Yeah, it's been discontinued.
> I recently had a chance to install PostgreSQL on Windows, and
> wanted to share my comments on the experience in the hope of
> making things better.
> Overall I was very impressed - th
Thinking more about other systems, ISTM that Oracle can do this, as can
any MVCC based system. OTOH DB2 and SQLServer take block level read
locks, so they can do this too, but at major loss of concurrency and
threat of deadlock. Having said that, *any* system that chose not to do
this would be sev
Related TODO paragraph:
«Prevent PQfnumber() from lowercasing unquoted the column name.
PQfnumber() should never have been doing lowercasing, but historically
it has so we need a way to prevent it.»
PQfnumber() Fix Proposal
In the current version of PQfnumber(), i
14 matches
Mail list logo