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
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
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
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
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