Re: [GENERAL] Q: How to convert int to date?

1998-06-23 Thread Marin D
On Tue, 23 Jun 1998, Mattias Kregert wrote: ->How do I convert INTEGER to DATE in 6.3.2? -> ->I have a table 'mytbl' with a column 'd' which is ->an integer, containing dates in YYMMDD form. Now, This is quite bad representation of date. U know Y2K, so on... ->how do I convert these integer

Re: [GENERAL] Foreign Keys

1998-06-09 Thread Marin D
PGSRC_DIR/contrib/spi/refint* is the answer Marin -= Why do we need gates in a world without fences? =- On Mon, 8 Jun 1998, ENTER YOU NAME HERE wrote: > Hi all > I am using PostgreSQL as part of my MSc project. Because it is an > object-relational database it is a superset

Re: [GENERAL] A couple of LIBPQ questions

1998-06-07 Thread Marin D
On Fri, 5 Jun 1998, Bruce Tong wrote: > (1) PQftype() returns a value of type "Oid", but I haven't been able to > find a list of what those values might be. I noticed in the header files a > value of zero is considered invalid, but that's it. The docs I've found > don't tell me anything other t

Re: [GENERAL] SQL Where Statement

1998-06-07 Thread Marin D
On Sat, 6 Jun 1998, Michael wrote: > > I am trying to do a select with a WHERE clause excluding all fields that > don't start with 'A'..'Z' > > Something in the form of > WHERE lastname >NOT LIKE ('A'..'Z') AND >NOT LIKE ('a'..'z') SELECT * FROM somewhere WHERE lastname !~ '[A

Re: [GENERAL] A couple of LIBPQ questions

1998-06-07 Thread Marin D
On Sat, 6 Jun 1998, Marin D wrote: > > > > > (2) I noticed there are some C++ classes in /usr/include/libpq++ which > > look similar to code I'm writing for my own education and use. Is there > > any documentation which deals with these classes?

[GENERAL] European/American dates

1998-06-03 Thread Marin D
Why does postgres (started *without* "-o -e") accept dates like "21-2-98" which is not (is it?) a valid American date? Thanx for the attention! Marin -= Why do we need gates in a world without fences? =-

[GENERAL] no shared libs

1998-05-31 Thread Marin D
Hi! I ve just upgraded from 6.2.1 to 6.3.2 and ended with no shared libs for libpq Making in the /interfaces/libpq(++) doesn't help - the libs are compiled only as libpq(++).a The configure script recognizes my system as linux-gcc which I think is standing now for linux-elf from the 6.2.1 rele

Re: [GENERAL] GRANT/REVOKE problems

1998-05-25 Thread Marin D
It doesnt make difference for postgres user. The result is the same for any user... Marin -= Why do we need gates in a world without fences? =- On Mon, 25 May 1998, Jose' Soares Da Silva wrote: > > Do you want revoke all previleges from postgres? > Remember that user postg