Why would one need a Primary Key... which can only be declared at table creation if
one can create a Unique Index post table creation?
ie: I deleted my primary key... is that a big deal? What's the purpose of the Primary
Key if it's function can be duplicated with another Unique Index?
thanks,
Sorry but this is making me crazy... yes... I'm way new to SQL
Why would this error out ??
This is the Query...
INSERT INTO OP (op_num,op_name,start_time) Values (5400,Welding,06:00:00);
And this is the pgSQL error...
ERROR: parser: parse error at or near ":"
The table has reasonable valu
At 01:39 AM 7/30/01 -0400, Tom Lane wrote:
>Gonzo Rock <[EMAIL PROTECTED]> writes:
>> Are all the date time functions described in the pgSQL docs are
>> ANSI-SQL or pgSQL extensions?
>
>One or the other, yes ;-)
Hey Tom,
You Clever guy!
Yes, One or the other!
Curious to know...
Are all the date time functions described in the pgSQL docs are ANSI-SQL or pgSQL
extensions?
For Example in the Docs:
4.7.1. EXTRACT, date_part
EXTRACT (field FROM source)
The extract function retrieves sub-fields from date/time values, such as yea
A Question for those of you who consider yourself crack Database Designers.
I am currently moving a large database(100+Tables) into pgSQL... with the intention of
deploying against 'any' SQL database in the future. The development side will be
rigorously using Standard SQL constructs with no un
A Question for those of you who consider yourself crack Database Designers.
I am currently moving a large database(100+Tables) into pgSQL... with the intention of
deploying against 'any' SQL database in the future. The development side will be
rigorously using Standard SQL constructs with no un
