Re: [GENERAL] LIMIT QUESTION

1999-04-28 Thread Chris Bitmead
Only PostgreSQL 6.5 Beta supports LIMIT. > I've an elementary question. What's wrong with the following : > > dbtest=> select * from testusers limit 10; > ERROR: parser: parse error at or near "10" > dbtest=> select version(); > version > ---

RE: [GENERAL] LIMIT QUESTION

1999-04-28 Thread Michael J Davis
I think "limit" is new with version 6.5. -Original Message- From: Martin Wong [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 28, 1999 8:07 PM To: [EMAIL PROTECTED] Subject:[GENERAL] LIMIT QUESTION Hi, I've an eleme

[GENERAL] LIMIT QUESTION

1999-04-28 Thread Martin Wong
Hi, I've an elementary question. What's wrong with the following : dbtest=> select * from testusers limit 10; ERROR: parser: parse error at or near "10" dbtest=> select version(); version - PostgreSQL 6.4.2 on i586-pc-linux-gnu, compi

Re: [GENERAL] PLpgSQL Stat Problem

1999-04-28 Thread Andy Lewis
Postgres is allowed to access that file. No error message on the: cat plpgsql.so > /dev/null Andy On Wed, 28 Apr 1999, Oleg Broytmann wrote: > On Wed, 28 Apr 1999, Andy Lewis wrote: > > I got the following error after trying to copy the example at: > > http://www.postgresql.org/mhonar

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Thomas Good
On Wed, 28 Apr 1999, Bruce Momjian wrote: > > Symbols from libucb.a[alloca.o]: > > [1] | 0| 0|FILE |LOCL |0|ABS|alloca.s > > [4] | 0| 0|NOTY |GLOB |0|1 |alloca > > Bing. Looks like bison-programs need -lucb as a compiler option. Try > that and see.

Re: [GENERAL] Any ideas why this doesn't work or how to rewrite it?

1999-04-28 Thread Aaron Holtz
Yes, I'm just taking the value ntuples returned after doing: select distinct customer_username from customerdata group by customer_username; I guess my big thing was that I saw a couple of select count(distinct something) from table; examples in an SQL book that I have. Was just curious as

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Bruce Momjian
> On Wed, 28 Apr 1999, Thomas Good wrote: > > > > It is this line: > > > > > > [56]| 0| 0|NOTY |GLOB |0|UNDEF |alloca > > > > > > Your bison is outputting code that can not be resolved by the libraries > > > you supplied. Try doing 'nm' in /usr/lib, and see if you can

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Bruce Momjian
> On Wed, 28 Apr 1999, Bruce Momjian wrote: > > > > On Wed, 28 Apr 1999, Bruce Momjian wrote: > > > > It is this line: > > > > [56]| 0| 0|NOTY |GLOB |0|UNDEF |alloca > > > > Your bison is outputting code that can not be resolved by the libraries > > you supplied. Tr

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Thomas Good
On Wed, 28 Apr 1999, Thomas Good wrote: > > It is this line: > > > > [56]| 0| 0|NOTY |GLOB |0|UNDEF |alloca > > > > Your bison is outputting code that can not be resolved by the libraries > > you supplied. Try doing 'nm' in /usr/lib, and see if you can find a > > ref

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Thomas Good
On Wed, 28 Apr 1999, Bruce Momjian wrote: > > On Wed, 28 Apr 1999, Bruce Momjian wrote: > > It is this line: > > [56]| 0| 0|NOTY |GLOB |0|UNDEF |alloca > > Your bison is outputting code that can not be resolved by the libraries > you supplied. Try doing 'nm' in /u

Re: [GENERAL] Any ideas why this doesn't work or how to rewrite it?

1999-04-28 Thread Bob Dusek
Hey there... > SELECT customer_username, COUNT(customer_username) FROM customerdata GROUP BY >customer_username; > The above query, in effect, does the same thing that: SELECT DISTINCT(customer_username) from customerdata does. In order to get the total number of distinct customer_username

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Bruce Momjian
> On Wed, 28 Apr 1999, Bruce Momjian wrote: > > > > or Linux) gmake barfs with: > > > Undefined symbol allocain file bootstrap/SUBSYS.o > > > The alloca calls are coming from the code generated by bison. Strange > > it would do that on Unixware. You would think bison would know if

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Thomas Good
On Wed, 28 Apr 1999, Bruce Momjian wrote: > > or Linux) gmake barfs with: > > Undefined symbol allocain file bootstrap/SUBSYS.o > The alloca calls are coming from the code generated by bison. Strange > it would do that on Unixware. You would think bison would know if > alloca was a

Re: [GENERAL] Search engine with PostgreSQL

1999-04-28 Thread valter
Wim Ceulemans wrote: > Hi > > Has anyone any experience whether it is possible to build with a PostgreSQl > database and a linux box a search engine for a portal? > i'm doing this. It's name will be GOLIATH > > Regards > > Wim Ceulemans - [EMAIL PROTECTED] > Nice Software Solutions - http://ww

Re: [GENERAL] UnixWare chokes

1999-04-28 Thread Bruce Momjian
> Hi all, > > Trying to build pg on unixware...hacked configure as follows > to create a Makefile: > > change TEMPLATE=template/`uname -s | tr A-Z a-z` > to TEMPLATE=template/univel > > Downloaded flex-2.3pl7.tar.Z from Freebird site, installed... > Downloaded bison-1.14.pkg.tar.Z a

Re: [GENERAL] Any ideas why this doesn't work or how to rewrite it?

1999-04-28 Thread Gene Selkov, Jr.
> This seems like a simple SQL command, but I'm getting errors. > Running 6.5.0 under RedHat 5.2: > > db=> select count(distinct customer_username) from customerdata; > ERROR: parser: parse error at or near "distinct" > > How do you get a count of distinct data output via postgres? SELECT cus

Re: [GENERAL] Any ideas why this doesn't work or how to rewrite it?

1999-04-28 Thread Aaron Holtz
Yes, that is what I'll have to do. Just counting the number of tuples returned from this query would work. I was just wondering why this wasn't implemented in postgres or what the valid syntax would be. Thanks! -- Aaron Ho