[SQL] AUTOINCREMENT--help
Is there a function in SQL that does autoincrementing... eg. CREATE TABLE (name varchar(40),num_id int); wherein num_id starts with 0 and then when ever I INSERT another record num_id goes 1 etc Thanks in advance
[SQL] Arithmetic operation on DATE
is it possible to add a date datatype column to a number resulting to a date.. theoretically it should do this,,, X is in months date + X = date --> 2001-08-20 + 6 = 2002-02-20 -- The information contained in this message (including any attachments) is confidential and intended solely for the attention and use of the named addressee(s). It must not be copied, distributed nor disclosed to any person. If you are not the intended recipient, please delete it from your system and notify sender immediately. Any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. -- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[SQL] Arithmetic operation on DATE
is it possible to add a date datatype column to a number resulting to a date.. theoretically it should do this,,, X is in months date + X = date --> 2001-08-20 + 6 = 2002-02-20 -- The information contained in this message (including any attachments) is confidential and intended solely for the attention and use of the named addressee(s). It must not be copied, distributed nor disclosed to any person. If you are not the intended recipient, please delete it from your system and notify sender immediately. Any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. -- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] Altering pg_conndefaults
how do i change the User in pg_conndefaults because the user is not valid to connect to DB. one thing i can do is to add the User but is there a way to change the user seen in pg_conndeafaults... thanks in advance -- The information contained in this message (including any attachments) is confidential and intended solely for the attention and use of the named addressee(s). It must not be copied, distributed nor disclosed to any person. If you are not the intended recipient, please delete it from your system and notify sender immediately. Any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. -- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] Altering pg_conndefaults
how do i alter values of pg_conndefaults? example user=user1 to user=user2 thanks in advance ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
