Re: [SQL] date array

2006-04-23 Thread Bruno Wolff III
Please keep responses copied to the list. This both helps other people with similar questions by getting the discussion in the archives and helps you by letting other people see your additional questions. On Sun, Apr 23, 2006 at 13:21:49 -0500, "A. R. Van Hook" <[EMAIL PROTECTED]> wrote: > I am

Re: [SQL] date array

2006-04-23 Thread Bruno Wolff III
On Sun, Apr 23, 2006 at 07:55:54 -0500, "A. R. Van Hook" <[EMAIL PROTECTED]> wrote: > How do you add null values to a date array? > > update dattable set insDate= '{04/12/2006,null}' <-- doesn't work That is the correct format. However, I think that only works in HEAD (what will become 8.2

[SQL] date array

2006-04-23 Thread A. R. Van Hook
How do you add null values to a date array? update dattable set insDate = '{04/12/2006,'null'}<-- doesn't work update dattable set insDate= '{04/12/2006,null}' <-- doesn't work update dattable set insDate= '{04/12/2006,''}' <-- doesn't work the table field is defined as insDate d

Re: [SQL] Primary key reference count

2006-04-23 Thread Wiebe Cazemier
On Wednesday 19 April 2006 19:21, Volkan YAZICI wrote: > Here's simple query, to list which table's which columns references to a > specific table. (Hope this is what you asked for.) > > SELECT TBL.table_name, COL.column_name > FROM information_schema.referential_constraints AS REF > INNE