I have fixed it. I have pg8.03 but database is 8.0. I dump database and
reload it, it work well.
Thank for your help.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "hatuan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 26, 2005 4:19 AM
Su
My version is "PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe
(GCC) 3.4.2 (mingw-special)"
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "hatuan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 26, 2005 4:19 AM
S
I use domain in my database
Ex
CREATE DOMAIN ud_id
AS bpchar(3)
DEFAULT ''::bpchar
NOT NULL;
And have table A
CREATE TABLE A
(
id ud_ma_nt NOT NULL,
name ud_name,
CONSTRAINT A_pkey PRIMARY KEY (id)
)
I have a select query Select * from A where id like 'US%'
In pgAdmin i have er
Thank you
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "tuan" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, April 30, 2005 10:56 AM
Subject: Re: [SQL] Division in Postgre
> On Sun, 24 Apr 2005, tuan wrote:
>
> > In sql server my division select cast(3 as float)/10 is 0.29
