Re: [GENERAL] download binary version for Win32

2005-08-21 Thread Jeff Eckermann
"Ulises Poirier" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > > I can't to download this version..can you help me? What did you do, and what happened? A copy-and-paste of a terminal session would be ideal. > > regards, > Ulises > > ---(end

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Clodoaldo Pinto
2005/8/21, Tom Lane <[EMAIL PROTECTED]>: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I think something like: > > (CASE WHEN extract(dow from date) = 0 THEN 7 else extract(dow from date)) > > It's really not that hard: > > (extract(dow from date) + 6) % 7 > > You can rotate to any wee

Re: [GENERAL] Help with plperl

2005-08-21 Thread Martijn van Oosterhout
On Mon, Aug 22, 2005 at 03:58:25AM +1000, Alex wrote: > Hi, > could anyone help me with a problem I am having creating a plperl function. > > The return always complains with the following error: > composite-returning Perl function must return reference to hash Well, since you're returning a refe

Re: [GENERAL] Help with plperl

2005-08-21 Thread Michael Fuhr
On Mon, Aug 22, 2005 at 03:58:25AM +1000, Alex wrote: > could anyone help me with a problem I am having creating a plperl function. > > The return always complains with the following error: > composite-returning Perl function must return reference to hash The above error tells you what's wrong: PL

[GENERAL] Help with plperl

2005-08-21 Thread Alex
Hi, could anyone help me with a problem I am having creating a plperl function. The return always complains with the following error: composite-returning Perl function must return reference to hash Thanks Alex CREATE TYPE sometype AS ( jid INTEGER, start_time TEXT, descr

Re: [GENERAL] How to get '-' in katakana with canna server

2005-08-21 Thread Madison Kelly
Madison Kelly wrote: > Hi all, > > I hope this is an on-topic question. :) Gah!!! I posted this to the wrong mailing list! (It was supposed to go to the i18n mailing list). I am really soory, please ignore this! Madison ---(end of broadcast)-

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Yeah, mod is probably better and more general than case. It's still fairly > ugly to require a non-trivial expression to get something that's > consistent with the way that extract(week from date) works. ;) > For anyone who is considering using this, to

[GENERAL] How to get '-' in katakana with canna server

2005-08-21 Thread Madison Kelly
Hi all, I hope this is an on-topic question. :) I have started using 'canna' as my Japanese input method and so far it's working pretty well. The one thing I haven't been able to figure out is how to type the '-' (lengthening stoke) on katakana words. For example, when I try to type "page"

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Jim C. Nasby
On Sun, Aug 21, 2005 at 08:00:45AM -0300, Clodoaldo Pinto wrote: > Of course it would be even better if we could pass parameters to the > functions changing its behavior such as sunday/monday as the first day > or 0-1 as the first day. FWIW, it seems most things that support changing first day of

Re: [GENERAL] ORDER BY time consuming

2005-08-21 Thread Jim C. Nasby
On Sun, Aug 21, 2005 at 12:04:01PM +0200, Ben-Nes Yonatan wrote: > Hi All, > > I got a table with about 4.5 millions rows in it which is connected to > another table with about 60 millions rows which are used as keywords for > searching. > > I succeded to create fast queries on the first table

[GENERAL] Windows Installer

2005-08-21 Thread John Craddock
Hello, I am not succeeding in the installation of postgresql on a win2000 box. I cannot find a specific list for Windows installer problems. If there is one I would appreciate being directed to the appropriate place. Description follows: - System: Win2000 SP3 NTFS file system All non-essential serv

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Stephan Szabo
On Sun, 21 Aug 2005, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I think something like: > > (CASE WHEN extract(dow from date) = 0 THEN 7 else extract(dow from date)) > > It's really not that hard: > > (extract(dow from date) + 6) % 7 > > You can rotate to any week-start

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I think something like: > (CASE WHEN extract(dow from date) = 0 THEN 7 else extract(dow from date)) It's really not that hard: (extract(dow from date) + 6) % 7 You can rotate to any week-start day you like by substituting different things for "

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Stephan Szabo
On Sun, 21 Aug 2005, Clodoaldo Pinto wrote: > 2005/8/21, Stephan Szabo <[EMAIL PROTECTED]>: > > On Sat, 20 Aug 2005, Tom Lane wrote: > > > > > Clodoaldo Pinto <[EMAIL PROTECTED]> writes: > > > > I'm ordering by date just to show that sunday, the 0th day of the > > > > week, is the last day of a gi

Re: [GENERAL] ipcc climate mdb problem

2005-08-21 Thread Tino Wildenhain
Am Sonntag, den 21.08.2005, 10:01 +0930 schrieb Geoff Russell: > Hi, > > I'm trying to access an IPCC climate database > >http://www-cger.nies.go.jp/ipcc/Ipccdbv1-20050512.zip > > This is an mdb file, I only use Linux and postgres and all the > migration tools seem to run only on Windows box

Re: [GENERAL] extract (dow/week from date)

2005-08-21 Thread Clodoaldo Pinto
2005/8/21, Stephan Szabo <[EMAIL PROTECTED]>: > On Sat, 20 Aug 2005, Tom Lane wrote: > > > Clodoaldo Pinto <[EMAIL PROTECTED]> writes: > > > I'm ordering by date just to show that sunday, the 0th day of the > > > week, is the last day of a given week, which is not what I need. > > > > extract(week

[GENERAL] ipcc climate mdb problem

2005-08-21 Thread Geoff Russell
Hi, I'm trying to access an IPCC climate database http://www-cger.nies.go.jp/ipcc/Ipccdbv1-20050512.zip This is an mdb file, I only use Linux and postgres and all the migration tools seem to run only on Windows boxes or rely on having an ODBC connection to a running windows server. If someon

[GENERAL] history is not supported by this installation

2005-08-21 Thread CSN
Hi, IIRC psql's "\s" used to work, but I upgraded to 8.x on Windows - which recommends that cygwin/bin be removed from PATH - and I get this error: "history is not supported by this installation" Reading the docs, it states GNU readline is required. I presume that that was in cygwin/path - what'

[GENERAL] ORDER BY time consuming

2005-08-21 Thread Ben-Nes Yonatan
Hi All, I got a table with about 4.5 millions rows in it which is connected to another table with about 60 millions rows which are used as keywords for searching. I succeded to create fast queries on the first table that finds a row at the first table which is connected to up to 4 diffrent k