Stephan Szabo wrote:
On Sun, 6 Jul 2003, Shachar Shemesh wrote:
Tom Lane wrote:
See also the example and footnote at the end of section 1.1.1 of our
documentation:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
(not sure why the lin
On Sun, 6 Jul 2003, Shachar Shemesh wrote:
> Tom Lane wrote:
>
> >See also the example and footnote at the end of section 1.1.1 of our
> >documentation:
> >http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
> >(not sure why the link to the footno
Tom Lane wrote:
See also the example and footnote at the end of section 1.1.1 of our
documentation:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
(not sure why the link to the footnote doesn't work in that version, but
the footnote is at the
Stephan Szabo <[EMAIL PROTECTED]> writes:
> I believe that it would require the identifiers in the following to
> be the same, whereas PostgreSQL would treat them as different.
See also the example and footnote at the end of section 1.1.1 of our
documentation:
http://www.postgresql.org/docs/view.p
>Postgresql, instead, makes the identifiers in the query lowercase. While
Which we know is incorrect. We should instead make it uppercase, but
that would break compatibility with older version (SQL 92 draft, 5.2 SR10)
>create table "Table" ( id int );
>select * from Table;
>You get "relation t
Michal Schwarz <[EMAIL PROTECTED]> writes:
> Ie. psql 7.2 obviously EXPECTS quotes, while pg_dump and pg_dumpall DO NOT
> GENERATE them.
This is fixed in 7.2.1 (we reverted psql's behavior).
regards, tom lane
---(end of broadcast)-
Sorry to sound like a broken record, but this is also fixed in 7.2.1.
---
Michal Schwarz wrote:
> Problem:
>
> pg_dump does not honour case-sensitivity in user names, which results to
> failures when restoring data
On Wed, 9 Jan 2002, Mike Hoolehan wrote:
> Please enter a FULL description of your problem:
>
> if a quoted column alias in a FROM clause sub-select contains upper-case
> chars, then that column cannot be later referenced without using quotes
>
> P
Mike Hoolehan <[EMAIL PROTECTED]> writes:
> SELECT * FROM (SELECT col1 as "Foo" from table1) AS innerQuery
> WHERE Foo = 'whatever';
> results in
> "ERROR: Attribute 'foo' not found"
> no matter what capitalization is used for "Foo" in the where clause
> (i.e. foo='whatever', FOO='whatever',
Mike Hoolehan writes:
> if a quoted column alias in a FROM clause sub-select contains upper-case
> chars, then that column cannot be later referenced without using quotes
This is expected behaviour. See also
http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/sql-syntax.html#SQL-SYNTAX
10 matches
Mail list logo
