[SQL] Change attribute of a column

Hi, I have a field in text[] and I want to change it to a datetime[]. Is it possible? how? Thanks very much. - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73

Re: [SQL] Index selection on a large table

"Michael Richards" <[EMAIL PROTECTED]> writes: > The following query yeilds the questionable query plan: > explain select * from logins where ip='38.30.141.44'; > NOTICE: QUERY PLAN: > Seq Scan on logins (cost=0.00..25248.51 rows=11602 width=48) If there really were 11602 matching rows, the se

Re: [SQL] pg_dump

sathya priya <[EMAIL PROTECTED]> writes: > when dump the database it throw > "getTables(): relation 'ordermaster': cannot find > function with oid 1655 for trigger > RI_ConstraintTrigger_2017354 " I think this must be another variant of the 6.5-pg_dump-with-7.0-database problem. There's no err

[SQL] Index selection on a large table

Hi. I believe this to be a bug, but I am submitting it to the SQL list as well in the case I overlooked something. I'm running Postgres 7.0.2 on FreeBSD 4.0-STABLE/Intel compiled with [gcc version 2.95.2 19991024 (release)] I've got this interesting problem where the query plan is not what

[SQL] pg_dump

hai when dump the database it throw "getTables(): relation 'ordermaster': cannot find function with oid 1655 for trigger RI_ConstraintTrigger_2017354 " any clues thank advance p. ashok kumar __ Do You Yahoo!? Get Yahoo! Mail – Free email you

Re: [SQL] command in C

> am i use "PQexec()" or "conn.query()" for inserting informations > in my BD ? I wrote a class to encapsulate all the ugliness of it. Inside my class I'm calling PQexec(). -Michael

[SQL] command in C++

am i use "PQexec()" or "conn.query()" for inserting informations in my BD ? thanks. Jerome.

RE: [SQL] primary key question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El 20-Jul-2000 Carolyn Lu Wong escribio: > create table aaa( > field1 not null, > field2 , > , > primary key (field1, field2) > ); > > Based on the above table definition, field2 allows null values. But > after