Re: [SQL] rows equal

2001-03-24 Thread Richard H
On 3/20/01, 7:23:04 PM, Marios Moutzouris <[EMAIL PROTECTED]> wrote regarding [SQL] rows equal: > Hello > I need a sql query to a postgresql database which can tell me whether the > rows returned ar equal. > i.e > --- > Status > --- > Order > --- > Collected > -- > This

Re: [SQL] SOME PL/PGSQL PROBLEMS

2001-03-23 Thread Richard H
On 3/23/01, 9:10:16 AM, datactrl <[EMAIL PROTECTED]> wrote regarding [SQL] SOME PL/PGSQL PROBLEMS: Sorry, can't reproduce this at all Jack > I found there are some problems with PL/pgSQL. > 1) 'Drop Table' doesn't work at all No problems in 7.1, can't remember about previous versions > 2) '--

Re: [SQL] MultiByte strings

2001-03-19 Thread Richard H
On 3/19/01, 10:13:40 AM, Tubagus Nizomi <[EMAIL PROTECTED]> wrote regarding [SQL] MultiByte strings: > Hello, > i have an error > "psql: ERROR: MultiByte strings (MB) must be enabled to use this function" > where i must enable MultiByte strings (MB) ?? Assuming you enabled this at the ./co

Re: [SQL] List Concatination

2001-03-15 Thread Richard H
On 3/15/01, 5:02:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote regarding Re: [SQL] List Concatination : > Josh Berkus <[EMAIL PROTECTED]> writes: > >> Note that this is probably not a good idea - the ordering of the > >> contacts will not be well-defined. When I asked about this Tom Lane was > >> qu

Re: [SQL] pl/Perl

2001-03-14 Thread Richard H
On 3/14/01, 5:04:49 PM, Jie Liang <[EMAIL PROTECTED]> wrote regarding Re: [SQL] pl/Perl : > Tom, I'm not the organ grinder, but maybe the monkey can help ;-) > 1.Where or how I can get pltcl.so? I have not find this file anywhere in > my > source except a pltcl.c. Did you set the relevant par

Re: [SQL] need to join successive log entries into one

2001-03-14 Thread Richard H
>> Original Message << On 3/14/01, 5:24:12 PM, George Young <[EMAIL PROTECTED]> wrote regarding [SQL] need to join successive log entries into one: > I have a table like: > run | seq | start| done > 1415|261| 2001-01-29 12:36:55| 200

Re: [SQL] PL/pgSQL "compilation error"

2001-03-14 Thread Richard H
On 3/14/01, 4:28:03 PM, Josh Berkus <[EMAIL PROTECTED]> wrote regarding Re: [SQL] PL/pgSQL "compilation error": > Tim, > > Hello all - I apologize for the newbie-esque question, but the debug output > > from postgres when you have a bug in your PL/pgSQL procedure is none to > > detailed. > I