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
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's
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
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) follows the ISO
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 boxes or
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 given week, which is
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 6.
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 day you like
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
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 that
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
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
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 get
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)---
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,
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:
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
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 week-start day
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 of
19 matches
Mail list logo