From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] dollar quoting |
Date: | 2004-02-15 20:55:36 |
Message-ID: | 402FDCC8.5000103@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Another interesting thing abut psql that I noticed when using '$' in
identifiers is this effect:
andrew=# create table ab$cd$ef (ef$cd$ab text);
CREATE TABLE
andrew=# \d ab$cd$ef
Did not find any relation named "ab$cd$ef".
andrew=# \d ab\$cd\$ef
Table "public.ab$cd$ef"
Column | Type | Modifiers
----------+------+-----------
ef$cd$ab | text |
which is perhaps slightly less than intuitive.
cheers
andrew
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2004-02-15 21:15:50 | Re: No Timeout in SELECT..FOR UPDATE |
Previous Message | Tom Lane | 2004-02-15 18:13:04 | Re: Proposals for PITR |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Campbell | 2004-02-15 21:50:41 | Crash when calling a pl/pgsql function with no row to pass as an argument |
Previous Message | Peter Eisentraut | 2004-02-15 19:40:15 | Re: Afrikaans translation of libpq |