[GENERAL] functions list

1999-01-08 Thread Murat Balkas
Hi, is there a detailed discription of postgresql functions which I get with \df. Or a detailed document about them. thanks... Murat

Re: [GENERAL] functions list

1999-01-08 Thread Bruce Momjian
> > Hi, > > is there a detailed discription of postgresql functions which I get with > \df. Or a detailed document about them. What more info do you need? Maybe the documenation in docs? -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]|

Re: [GENERAL] functions list

1999-01-08 Thread Murat Balkas
Some detailed discription, some examples, bu at least the list of them. I can't put the output of \df command to a file. Murat On Fri, 8 Jan 1999, Bruce Momjian wrote: > > > > Hi, > > > > is there a detailed discription of postgresql functions which I get with > > \df. Or a detailed docum

Re: [GENERAL] functions list

1999-01-08 Thread Gene Selkov Jr.
> I can't put the output of \df command to a file. psql -d database -c "\df" > file

Re: [GENERAL] functions list

1999-01-08 Thread Bruce Momjian
> > Some detailed discription, some examples, bu at least the list of them. I > can't put the output of \df command to a file. Try: echo "\\df" | psql test >file There is a short one-line description of each one. Do you need more? -- Bruce Momjian| http

[GENERAL] Using Memory

1999-01-08 Thread Sergei Chernev
Hello, My programm uses postgres every minute, thats why i keep connection to postgres all the time my programm live. When the programm just started postmaster gets about one meg. But in few days after the postmaster process grow up to 15 Mb in memory, thow my databases are small enough (approx

Re: [GENERAL] select using date

1999-01-08 Thread Jose' Soares
Try: select current_date, CURRENT_DATE - INTERVAL '1 DAY'; ?column?|?column? --+-- 1999-01-08|1999-01-07 00:00:00+01 (1 row) PostgreSQL has a syntax sligth different than SQL92. You have to enclose '1 DAY' instead of '1' DAY. -Jose'- Kevin Heflin wrote: > > Tryi

Re: [GENERAL] select using date

1999-01-08 Thread Kevin Heflin
On Fri, 8 Jan 1999, Jose' Soares wrote: > Try: > > select current_date, CURRENT_DATE - INTERVAL '1 DAY'; > ?column?|?column? > --+-- > 1999-01-08|1999-01-07 00:00:00+01 > (1 row) > > PostgreSQL has a syntax sligth different than SQL92. You have to enclose > '1 DAY

[GENERAL] Callable Statement in JDBC

1999-01-08 Thread Sze Yuen Wong
Hi, I'm using Postgre in my Java program. The Java bean (JCDatasource from KL group) require callable statement when saving to the DB. But Postgre report Callable statement is not supported. Anybody knows if 6.4 support callable statement? Or anyother ways to work around? Thank you very much.

Re: [GENERAL] Patch 6.4.1 to 6.4.2

1999-01-08 Thread Stefan Hornburg
The Hermit Hacker <[EMAIL PROTECTED]> writes: > On Wed, 6 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote: > > > > > Hi! > > > > Where can I find the required patch to upgrade 6.4.1 to 6.4.2 ? > > There is no patch for this...we've tried in the past to create "clean" > patches, and each time

[GENERAL] postgresql v6.4.2 c funcs and null text pointers...

1999-01-08 Thread Walt Bigelow
I wrote a c func (ATTACHED BELOW) which takes 2 pointers to type text, and a bool field. When a field in a row passed to the func is null, espically the 'first' field, Postgresql does not return the value that my code produced. For example: First lastco nocompany ---

[GENERAL] Benchmarking PGSQL against Microsoft SQL 7.0?

1999-01-08 Thread Bryan Field-Elliot
Please forgive my newbieness but I am extremely new to both Postgresql AND Linux. I've been a consultant for 6 years working mostly on Microsoft platforms (NT, MSSQL). I have developed many data-driven websites using WinNT/IIS/ASP/MSSQL. Now, getting sick of MS and being enamored with the whole Op

RE: [GENERAL] postgresql v6.4.2 c funcs and null text pointers...

1999-01-08 Thread Jackson, DeJuan
Very observant of you. The postgres function system doesn't have a way to tell which parameter is null, so the function just returns null. I don't like it and we hope to get it changed for PGv6.5 (at least I do). Is it on the TODO guys? Jan, do you think you'll have the time to get to it by bet

RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7.0?

1999-01-08 Thread Jackson, DeJuan
There has been a discussion in the HACKERS list (check the archives on the website [http:\\www.postgresql.org\]) about PostgreSQL vs MS SQL 6.5 for the last 2 days or so. I think these ideas must come in threes, so where is that other person? I can't really give a feature comparison of MS SQL 7

Re: [GENERAL] Callable Statement in JDBC

1999-01-08 Thread Peter T Mount
On Fri, 8 Jan 1999, Sze Yuen Wong wrote: > Hi, > > I'm using Postgre in my Java program. > The Java bean (JCDatasource from KL group) > require callable statement when saving to > the DB. But Postgre report Callable statement > is not supported. > Anybody knows if 6.4 support callable statemen