[SQL] Fw:

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 da

[SQL] Fw:

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 da

Re: [SQL] EXCEPT Queries

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" |

Re: [SQL] once again, sorting with Unicode

There are various examples in the example source code section of the postgres distribution, where you can find code you can use to write exactly the kind of funtion you need. I can't immediately include source code from us, but I can include the gist of how the code works. The basic idea is to co

[SQL] pg_func problem

Hi All, I am trying to use the function below, it works fine on my dev server running 7.2.3 but does not work on my production server running 7.1.2. (both on linux) Would anyone be able to shed some light on why this is the case. The error I get is: ERROR during compile of 'change_sup_ord_statu

[SQL] How to drop all the sequences

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  

Re: [SQL] PL/PGSQL EDITOR

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 o

Re: [SQL] point <-> polygon not supported?

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] VIEW or Stored Proc - Is this even possible?

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 t