Re: [SQL] plpgsql, double quoted column names containing spaces/hyphens

2003-06-21 Thread Tom Lane
"Knut P. Lehre" <[EMAIL PROTECTED]> writes: > Using pgsql 7.2.1 (PeerDirect beta4) on WinXP Prof SP1. Client: MS > In plpgsql, I can access columns with a name containing capital letters by > enclosing the name in double quotes: tbl."ColName" > However, if the quoted name contains spaces or hyph

[SQL] plpgsql, double quoted column names containing spaces/hyphens

2003-06-21 Thread Knut P. Lehre
Using pgsql 7.2.1 (PeerDirect beta4) on WinXP Prof SP1. Client: MS VStudio2003 C++ -> ADO -> ODBC 7.03.01.00. In plpgsql, I can access columns with a name containing capital letters by enclosing the name in double quotes: tbl."ColName" However, if the quoted name contains spaces or hyphens I get

Re: [SQL] date question

2003-06-21 Thread javier garcia - CEBAS
Hi all; Peter, thank you very much for your help. Just a little thing. I've done as you say: CREATE TABLE rain_series_dated AS SELECT (year * interval '1 year' + month * interval '1 month' + day * interval '1 day') AS fecha,est7237,est7238,est7239,est7250 FROM rain_series ORDER by fecha; I se