RE: [GENERAL] LIMIT QUESTION

1999-04-29 Thread Martin Wong
Sorry for the previous posting. The following worked. BTW, this affects just this database or throughout the entire postgresql server? And, how does one reset this variable to max? Thanks martin -Original Message- ·ol : Margarita Barvinok <[EMAIL PROTECTED]> ˆ¶æ : [EMAIL PROTECTED]

RE: [GENERAL] LIMIT QUESTION

1999-04-29 Thread Martin Wong
uction? Please comment. And also if 6.4.2 is up to production level. I'm sure it is though, haven't found any problems yet. Thanks Martin -Original Message- ·ol : José Soares <[EMAIL PROTECTED]> ˆ¶æ : Chris Bitmead <[EMAIL PROTECTED]> CC : Martin Wong <

[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

[GENERAL] DISPLAYING BLOBS/images/text

1999-01-22 Thread Martin Wong
Dear all, I have a pgsql database table packed with images and another one packed with text files, all blobs. I have a script in perl which first extracts the images/text via the lo_export into a temp directory on my server and then it'll display the contents of the file on an HTML page passing H