* Tom Lane <[EMAIL PROTECTED]> [2004-03-04 11:24:11 -0500]: <snip> > Double quotes are for names (identifiers). Single quotes are > for string literals (constants).
BTW: is this general SQL syntax or just PostgeSQL ? mysql does no distinction (which is IMHO very unclean), and it gets even worse since mysqldump's output does it exactly the wrong way: identifiers in '' and string constants in "" ... cu -- --------------------------------------------------------------------- Enrico Weigelt == metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 174 7066481 --------------------------------------------------------------------- -- DSL-Zugang ab 0 Euro. -- statische IP -- UUCP -- Hosting -- --------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
