Re: [GENERAL] Disable the more command

Froilan Mendoza wrote: > >On Fri, 21 Jul 2000, Marcos Barreto de Castro wrote: > >>Can someone tell me how can I disable the more >> command at the end of any one page display in >> PostgreSQL 7.0 ? I simply don't want to be asked to >> press a key to continue displaying the resu

RE: [GENERAL] how connect visual basic to pgsql?

Hi, I have installed ODBC support in PG- PostgreSQL ODBC driver for Windows 95 (I'm using Win-NT-Wks 4.0) ODBC Driver Name - PostgreSQL 6.50. Company Name - Insight Distribution System File Name - PSQLODBC.DLL Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet and FTP

Re: [GENERAL] Can't put sub-queries values in queries results?

Manuel Lemos wrote: > > Hello, > > I want to look in a table and count how many rows of other table have a given > field that matches the value of the first table. I don't want to join because > if there are no matches for a given value of the first table, the query > does not return me any resu

Re: [GENERAL] how connect visual basic to pgsql?

At 16:53 21/07/00 -0500, Ingenieria de Sistemas wrote: >I am a beginner in pqsql and linux. >I can't connect from visual basic to my pgsql server. >When do I do telnet "host-pgsql" what is the message that have i receive >from pgsql server if my postgres port is enabled? >I just can read " connect

Re: [GENERAL] Disable the more command

On Fri, 21 Jul 2000, Marcos Barreto de Castro wrote: > Can someone tell me how can I disable the more > command at the end of any one page display in > PostgreSQL 7.0 ? I simply don't want to be asked to > press a key to continue displaying the result of a > query. Hmm. I don't have the

[GENERAL] Can't put sub-queries values in queries results?

Hello, I want to look in a table and count how many rows of other table have a given field that matches the value of the first table. I don't want to join because if there are no matches for a given value of the first table, the query does not return me any results for that value. For instance I

[GENERAL] how connect visual basic to pgsql?

I am a beginner in pqsql and linux. I can't connect from visual basic to my pgsql server. When do I do telnet "host-pgsql" what is the message that have i receive from pgsql server if my postgres port is enabled? I just can read " connect to "host-pgsql", then i type anything and press enter . I r

Re: [GENERAL] Disable the more command

* Marcos Barreto de Castro <[EMAIL PROTECTED]> [000721 12:45] wrote: > Hi, > > Can someone tell me how can I disable the more > command at the end of any one page display in > PostgreSQL 7.0 ? I simply don't want to be asked to > press a key to continue displaying the result of a > query.

[GENERAL] Disable the more command

Hi, Can someone tell me how can I disable the more command at the end of any one page display in PostgreSQL 7.0 ? I simply don't want to be asked to press a key to continue displaying the result of a query. Thanks a lot! Marcos Castro ___

Re: [GENERAL] Sort

- Original Message - From: "Nathan Barnett" <[EMAIL PROTECTED]> To: "'Mitch Vincent'" <[EMAIL PROTECTED]> Sent: Friday, July 21, 2000 3:03 PM Subject: RE: [GENERAL] Sort > Here is the query: > > SELECT Impression.AdNumber_AdNum, > Impression.Webmaster_WebmasterNum, > Impression.

[GENERAL] Re: [SQL] password encryption

On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote: > Hello, > > I want to encrypt passwords with Postgresql the way mySQL does it with : > > UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; Check out the ALTER command. ALTER USER username [ WITH PASSWORD 'passw

[GENERAL] Re: [SQL] problem with view and case - please help

the idea of a funtion is a good idea, thanks a lot ! i am a newbie to sql, after some try, i have made a function like this : create function browser(text) returns text AS 'SELECT CASE WHEN $1 LIKE \'%MSIE 2.0;%\' THEN \'Internet Explorer 2.0\' WHEN $1 LIKE \'%MSIE 3.0;%\' THEN \'Internet Explor

[GENERAL] Re: [BUGS] problem with view and case - please help

Ange Michel POZZO <[EMAIL PROTECTED]> writes: > CREATE VIEW browser > AS > SELECT > agent_i, > CASE > < massive CASE expression > > ELSE agent_i END AS navigateur, count (agent_i) > as total from access group by agent_i; > pqReadData() -- backend closed the channel unexpectedly. Not sure why you

[GENERAL] Re: [BUGS] problem with view and case - please help

Ange Michel POZZO wrote: > I repost my message because it seems that my previous post don't go on > > i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] > rpm version of Linux Mandrake 7.02 > That's definitely the problem. I cannot recreate it with current CVS sour

[GENERAL] problem with view and case - please help

I repost my message because it seems that my previous post don't go on i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] rpm version of Linux Mandrake 7.02 i try this query : [ange@ange ange]$ psql zonecommerce -h 192.0.1.84 -u -f toto.sql Username: postgres Password: DROP