Hi ,With this table :create table test(satu char(10),dua char(5));To get the field length, I use this query:select atttypmod from pg_attribute where attname='satu' and attrelid=(select oid from pg_class where relname='test');---> result 1 : 14select atttypmod from pg_attribute where attname='dua' a
I've this table :create table test(]satu char(10),dua char(5));How could I get the Field length not the Data length ?Thanks,Rina
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2ยข/min with Yahoo! Messenger with Voice.
Hi,
I would like to migrating my database from postgresql
7.4.6 to postgresql 8.0.3.
Are there any problem during migrating database? a
casting problem or sintax problem, or other problem?
Can somebody help me answering this question?
Or
Does anyone ever try to migrating database from
postgresql 7
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 06, 2005 at 10:05:06PM -0700, Louise
> Catherine wrote:
> > When I execute this statement :
> > select AGE(TO_DATE('20041101','mmdd'),
> > TO_DATE('19991201',&
When I execute this statement :
select AGE(TO_DATE('20041101','mmdd'),
TO_DATE('19991201','mmdd'))
at postgre 7.3.3, the result :
age
-
4 years 11 mons 1 day
at postgre 8.0.3, the result :
age
---
4 years 11 mons
I guess there's no other way,except adding the table
name one by one.
Thank you very much,
Louise Catherine.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
postgresql 7.3.3 to postgresql 8.0.3,
and I have a lot of case like one above
at my postgresql 7.3.3 databases.
Thanks,
Louise Catherine
NB: Sorry for my poor English
Start your day with Yahoo! - make it your home page
http:/
Hallo,
I found a problem making new data type kata,expecially
when make the C file ,can anyone help me solve it.
This error occur when I'm compiling the C file :
/usr/lib/gcc-lib/i586-suse-linux/3.3.1/../../../crt1.o(.text+0x18):
In function `_start':
../sysdeps/i386/elf/start.S:98: undefined ref
