Re: [SQL] id and ID in CREATE TABLE

2002-07-19 Thread Josh Jore
Joshua b. Jore ; http://www.greentechnologist.org On Sat, 20 Jul 2002 [EMAIL PROTECTED] wrote: > Why is like this ? Why not letting them upper case if they are not quoted > ? > > stefan Well.. this is because pgadmin created the attribute as "ID" originally so for you - it's always been doubl

Re: [SQL] Scan SQL

2002-07-23 Thread Josh Jore
On Tue, 23 Jul 2002, Roberto Mello wrote: > On Tue, Jul 23, 2002 at 10:11:18AM -0300, Sandro Joel Eller wrote: > > Hi > > > > I need to make a parser in a sql to get tables and fields to verify the > > privileges. Do anybody know software, function or anything that can help me? > > > > I found so

Re: [SQL] POSIX-style regular expressions

2002-09-10 Thread Josh Jore
On Tue, 10 Sep 2002, Goran Buzic wrote: > id1char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'), > ERROR:ExecAppend: rejected due to CHECK constraint table_name1_id1 > > I tested preceding regular expression with Perl and JavaScript and it worked > fine. Can I use regular expressio