Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

1999-08-20 Thread Zakkr
. why not: ..see a /postgresql-6.5.1/contrib/spi directory in PostgreSQL source package. Zakkr

Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)

1999-08-20 Thread Zakkr
); -- NOTE: If you run trigger AFTER|BEFORE insert in CurrentTriggerData is set 'tg_trigtuple' only. > Did you understand? ;-) And you? :-) Zakkr

Re: [GENERAL] Slow lookups on dates? Or something else?

1999-10-26 Thread Zakkr
ted routine, this func. must internal parse and search your 'day' - it is slowly. (.. instead of datetime_date() which make date from full DateTime only.) Zakkr -

Re: [GENERAL] operator *=

1999-12-09 Thread Karel Zak - Zakkr
On 9 Dec 1999, Sascha Ziemann wrote: > Hi, > > I have two tables "user_t" and "email_alias_t". The "user_t" table > has the two fields "last_name" and "linux_login" and the > "email_alias_t" table has the two fields "login" and "alias". > > In some rows in the "user_t" table the entry "linux_

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Karel Zak - Zakkr
> administrator. > > We are going to do very long tuples in 7.0 and 7.1. This may make large > objects obsolete. You can try for LO dump: ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.3.tar.gz I write this program for my private project, but I can continue

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Karel Zak - Zakkr
On Sun, 26 Dec 1999, Howie wrote: > On Sat, 25 Dec 1999, Bruce Momjian wrote: > > > > > > > > > > On Sat, 25 Dec 1999, Bruce Momjian wrote: > > > > My big question is, what new challenges will we face as > > > > we become more popular? > > > > > > Plug-in Oracle 7 compatibility. > > > > I

Re: [GENERAL] More newbie question: Restructuring a table

2000-03-01 Thread Karel Zak - Zakkr
On Wed, 1 Mar 2000, Timothy Grant wrote: > Hi again, > > Is there a quick and dirty way that I am missing for creating a new > database with a slightly different schema than the old db? > > For example, I have a table with a DATETIME field that I really need to > change to a DATE field. > > I

Re: [GENERAL] Use of datepart() on TimeStamp.

2000-02-01 Thread Karel Zak - Zakkr
On Tue, 1 Feb 2000, Jose Soares wrote: > I suppose do you refer to PostgreSQL date_part() function, while datepart() is a > M$Access function. Sorry, next time I read it better... Hmm, datepart/date_part, it is very simular - IMHO any Micro$oft surely copy this function from the best SQL - f