Re: [SQL] expression_tree_walker: Unexpected node type 711

2004-08-29 Thread Tom Lane
Ian Percival <[EMAIL PROTECTED]> writes: > SQL THAT IS THROWING ERROR: > select > calendar_date > from > official_hour > where > official_hour is not null > and office_closed = False > and calendar_date >= date'2004/01/01' > and calendar_date <= date'2004/08/23' > order by > calendar_

[SQL] expression_tree_walker: Unexpected node type 711

2004-08-29 Thread Ian Percival
I am having a problem with a select statement and the error expression_tree_walker: Unexpected node type 711 is being returned when I am trying to execute a rather simple SELECT statement. Any insight anyone could give me would be greatly appreciated. And if this is the wrong place to ask this

[SQL] Abwesenheitsnotiz: approved document

2004-08-29 Thread Gerdes, Heino
Sehr geehrte Damen und Herren, ich bin bis einschl. 27.08.2004 nicht im Büro. In dringenden Fällen wenden Sie sich bitte an das Sekretariat, Frau Braun-Scheibe , Tel. 0511/645-3485. Heino Gerdes MFG Heino Gerdes ---(end of broadcast)--- TIP 6:

Re: [SQL] backup of a specific schema

2004-08-29 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kenneth Gonsalves wrote: | On Saturday 28 August 2004 06:18 pm, Gaetano Mendola wrote: | | |>| |>| backup/restore |> |>Well, that chapter speak about pg_dump, don't you had the curiosity |>to look at the complete options for that command ? :-) | | | yes