Just discovered that column::date works fine but to_date(column, 'DD.MM.YY')
causes the problem. I was trying to write portable SQL, but never mind!
Andy
""Andy Marden"" <[EMAIL PROTECTED]> wrote in message
007301c1baad$b60d7b90$010a@marden1">news:007301c1baad$b60d7b90$010a@marden1...
>
Is there a repository on the web somewhere of all the bugs found, versions
they are found against and what theire status is?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEm
Great! But where is the documentation on doing this
stuff? I'd like to try.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Peter <[EMAIL PROTECTED]> writes:
> > I resorted to trial and error. Initdb hangs when
> "Creating template1
> > database" so there must be a step missing.
>
> I think you forgot
> Just discovered that column::date works fine but to_date(column, 'DD.MM.YY')
> causes the problem. I was trying to write portable SQL, but never mind!
Portable (as in SQL9x) would be
cast(column as date)
which is also accepted by PostgreSQL...
- Thomas
---
> "TL" == Tom Lane <[EMAIL PROTECTED]> writes:
TL> HISTORY says, under "Migration to version 7.2":
TL> * The date/time value 'current' is no longer available. You
TL>will need to rewrite your applications.
I see now. Thanks. I didn't make the connection between "current"
and
i have installed postgreSql Server on
windows2000
but on startup it gives a message Version
expired
Pls help
Hardeep Singh BhatiaSoftware AnalystNeel
Software Pvt LtdUnit 17, Electronics Sadan IIIMIDC, Bhosari, Pune
411026Ph: +(91)-(20)-712 9421 E-Mail: [EMAIL PROTECTED]
PL/pgSQL docs say "PL/pgSQL variables can have any SQL datatype".
but when i try:
CREATE FUNCTION foo() RETURNS NUMERIC(5,2) AS '
DECLARE
bar NUMERIC(5,2);
BEGIN
bar := 123.45;
return bar;
END;
' LANGUAGE 'plpgsql';
then "select foo()" gives:
NOTICE: plpgsql: ERROR dur
Angus Lees <[EMAIL PROTECTED]> writes:
> from a quick look at plpgsql/src/gram.y, the decl_dtypename rule
> only allows type modifiers (decl_attypmod) on CHAR, VARCHAR or BPCHAR.
This is fixed in 7.2.
regards, tom lane
---(end of broadcast)---
Hi Andy,
Thats the reason which techdocs.postgresql.org started for, but since it's
grown to encompass so many things, that section hasn't been updated in ages.
:-(
Perhaps its time to look at a better way of keeping it updated?
:-)
Regards and best wishes,
Justin Clift
On Thursday 21 Feb
Hi Paul,
You might like to try the very good installation guide for PostgreSQL on
Windows at :
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp
Added a link to it from the techdocs.postgresql.org website earlier
today too.
:-)
Regards and best wishes,
Justin Clift
On Thursday 21 Februa
Is this a TODO item? Seems so. Comments?
---
Tom Lane wrote:
> "Mark Jeacocke" <[EMAIL PROTECTED]> writes:
> > select DISTINCT TABLEID, '' AS ALIAS from TABLE; :FAILS
>
> We get this type of complaint regularly. Perhaps
BAZIN Nicolas ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
ecpg does not parse correctly define and struct in the same file
Long Description
The following example does not get pre-processed:
EXEC SQL ifndef COMMERCANT;
EXEC
This has been saved for the 7.3 release:
http://candle.pha.pa.us/cgi-bin/pgpatches2
---
[EMAIL PROTECTED] wrote:
> Craig Brown ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more
Peter wrote:
>
> Justin Clift suggested:
> http://www.ejip.net/faq/postgresql_win_setup_faq.jsp
> I started from scratch following the page and adapting it where it is
> out of date. I reached the stage of starting postmaster and receiving
> the message:
> DEBUG: pq_recvbuf: unexpected EOF on cli
14 matches
Mail list logo
