Hello,
To alter table column from varchar(32) to date. "Alter table" command
does not seem to work:
alter table test alter column col type date ;
ERROR: column "col1" cannot be cast to type "date"
Tks,
Emi
---(end of broadcast)---
TIP 7: don't for
Greetings,
I have a simple question about SQL command :
create table tableName1 LIKE parentTable INCLUDING defaults ;
I was trying to create table "tableName1" with the same structure as
"parentTable" without any data. I got a syntax error:
'syntax error at or near "like" ... '
I guess t
Greetings,
A question about creating index for the following expression.
CREATE INDEX idx_t1 ON test (col1 || '-' || col2);
May I know is it possible and how I may create index for the expression
such as "col1 || '-' || col2" for a table please?
Thanks a lot,
Emi
-
On Fri, Jul 08, 2005 at 12:08:41PM -0400, Ying Lu wrote:
CREATE INDEX idx_t1 ON test (col1 || '-' || col2);
May I know is it possible and how I may create index for the expression
such as "col1 || '-' || col2" for a table please?
"The syntax o
Hello,
May I know the commands to retrieve objects' privileges info please?
Something like:
Object Type, Object name,creator,grantee,
privilege, is_creatable
=
table T1