Re: cvs: php-src /ext/pdo_pgsql pgsql_driver.c

From: Date: Thu, 07 Jul 2005 02:06:45 +0000
Subject: Re: cvs: php-src /ext/pdo_pgsql pgsql_driver.c
References: 1 2 3  Groups: php.cvs 
Request: Send a blank email to php-cvs+get-32731@lists.php.net to get a copy of this message
Have you ever tried creating a sequence with an apostrophes in its name in PostgreSQL?
Easily, and don't forget about schema qualification either: test=# create sequence "isn't this ""grand""?"; CREATE SEQUENCE test=# \ds
                 List of relations
 Schema |        Name         |   Type   |  Owner
--------+---------------------+----------+--------- public | isn't this "grand"? | sequence | chriskl (1 row) test=# select nextval('"isn''t this ""grand""?"'); nextval ---------
       1
(1 row) test=# select currval('"isn''t this ""grand""?"'); currval ---------
       1
(1 row) test=# select currval('"public"."isn''t this ""grand""?"'); currval ---------
       1
(1 row) Chris

« previous php.cvs (#32731) next »