Re: [GENERAL] 7.4.2 Regression tests: test stats loops indefinately...

2004-05-04 Thread Manfred Koizar
On Mon, 3 May 2004 20:47:31 -0400, Vikram Kulkarni <[EMAIL PROTECTED]> wrote: >test=# SELECT timeofday(); > timeofday >- > Wed Dec 31 16:00:00.591964 1969 PST >(1 row) >[...] >That obviously doesn't look right. Isnt' timeofday() supposed to return >t

Re: [GENERAL] C Functions, datatypes

2004-05-04 Thread Karel Zak
On Mon, May 03, 2004 at 12:48:19PM -0700, A Palmblad wrote: > I'm writing a function in C, and am trying to return a row, containing > Numeric and array types. I'm building the row with heap_formtuple. > I'm having trouble creating the numeric and array Datums. If anyone > has some example

[GENERAL] create synopsis wrong ?

2004-05-04 Thread BRINER Cedric
Synopsis CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE /table_name/ ( { /column_name/ /data_type/ [ DEFAULT /default_expr/ ] [ /column_constraint/ [, ... ] ] | /table_constraint/ } [, ... ] ) [ INHERITS ( /parent_table/ [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] .. .. so this will mean

Re: [GENERAL] BUG ? or SQL miss understanding ?

2004-05-04 Thread Manfred Koizar
On Wed, 28 Apr 2004 12:33:15 +0300, "Bogdan Vatkov" <[EMAIL PROTECTED]> wrote: >SQL error: >ERROR: JOIN/ON clause refers to "vras_audio_records", which is not part of JOIN In SELECT ... FROM a, b LEFT JOIN c ON (a.id = ...) the LEFT JOIN operator has higher precedence than the comma, so

[GENERAL] pgsql documentation error ?

2004-05-04 Thread BRINER Cedric
Synopsis CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE /table_name/ ( { /column_name/ /data_type/ [ DEFAULT /default_expr/ ] [ /column_constraint/ [, ... ] ] | /table_constraint/ } [, ... ] ) [ INHERITS ( /parent_table/ [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] so this means that every