Re: [SQL] VIEW or Stored Proc - Is this even possible?

2003-02-20 Thread Stephen . Thompson
Thanks for that Richard, I will try your suggestions. I'll let you know my results. Regards, Stephen. -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:08 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [SQL] VIEW or Stored Proc - Is

Re: [SQL] point - polygon not supported?

2003-02-20 Thread Scott Ding
Tomasz, This works! Thanks, Scott Ding -Original Message- From: Tomasz Myrta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 9:06 AM To: Scott Ding Cc: [EMAIL PROTECTED] Subject: Re: [SQL] point - polygon not supported? Scott Ding wrote: Tomasz, Thanks for the tip.

Re: [SQL] EXCEPT Queries

2003-02-20 Thread Jeff Boes
On Thu, 20 Feb 2003 01:22:33 -0500, Mark Mitchell wrote: Here is an example of what I'm currently doing. TABLE A SUBSCRIBER_NAME | ACCOUNT_NUMBER -- BOB | 01 JOE | 02 TABLE B SUBSCRIBER_NAME | ACCOUNT_NUMBER

[SQL] Fw:

2003-02-20 Thread
pgsql-sql hello: when instal postgresql7.3.2 .in windows2000 I have install Cygwin 1.3.3 postgresql-7.3.1-1 cygipc-1.09-2 all successful but when I initdb -D /usr/local/pgsql/data I got the following messages: User Posted: 2003-02-13 15:19 The files belonging to this database system

[SQL] Fw:

2003-02-20 Thread
pgsql-sql hello: when instal postgresql7.3.2 .in windows2000 I have install Cygwin 1.3.3 postgresql-7.3.1-1 cygipc-1.09-2 all successful but when I initdb -D /usr/local/pgsql/data I got the following messages: User Posted: 2003-02-13 15:19 The files belonging to this database system

Re: [SQL] PL/PGSQL EDITOR

2003-02-20 Thread Josh Berkus
Folks, One more note on the PostgreSQL SQL highlighting mode for Kate: Shane Wright, the author, has asked for feedback. So if you use it, please send feedback and requests to me and I'll forward them. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

[SQL] How to drop all the sequences

2003-02-20 Thread Arunachalam Jaisankar
I found sequences are not getting dropped when tables are dropped. It is too difficult to drop all sequences one by one manually. Is there any command to drop all sequences in a database? Looking for help. regards Jaisankar