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

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] Future of PostgreSQL

1999-12-27 Thread Karel Zak - Zakkr
On Sun, 26 Dec 1999, Bruce Momjian wrote: > > - A dump program that can dump/restore large objects. > > > > Don't get me wrong. I'm not complaining, and we work with PostgreSQL a lot > > without any big problems. Just some ideas to make it easier for the > > administrator. > > We are going to

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_