[SQL] Re: binary operators

Frederic Metoz wrote: > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? Depending on what you're doing...you might get away with using mathematical operators to accomplish the above... A right SHIFT would be dividing by 2. A left shift would be multipl

[SQL] Rownum/ row Id

Hi, Is there a provision to delete the duplicate records using row num/ row id as available in Oracle??? Thanx in advance padmajha

Re: [SQL] Is this feature a bug?

Christopher Sawtell wrote: >Is the "( 1 row)" string really supposed to be there? >imho it should not be. >How can I turn it off? \pset tuples_only or \t or start psql with the -t option. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight

Re: [SQL] DROP Column

Keith Gray wrote: >Is DROP Column implemented in 7.x? No -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 0

Re: [SQL] binary operators

On Wed, 31 Jan 2001 04:12, Frederic Metoz wrote: > Hello, > > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? AND and OR . yes. SHIFT I don't think so. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45

Re: [SQL] Automated scripting...

On Wed, 31 Jan 2001 12:54, [EMAIL PROTECTED] wrote: > Hi, > > I'm building a script to create a relatively large database. At some > point in the script I would like to be able to save values into > variables so that I can use them to populate rows. > > Is this possible with SQL? My understandin

[SQL] Permissions for foreign keys

I'm using 7.0 and have noticed that I need to grant SELECT and UPDATE permissions on any referentially-related tables. Can/should I get around this? A somewhat contrived example: CREATE TABLE emp ( id integer PRIMARY KEY, salary integer ); CREATE TABLE proj ( id integer PRIMARY KEY, emp_id

[SQL] Automated scripting...

Hi, I'm building a script to create a relatively large database. At some point in the script I would like to be able to save values into variables so that I can use them to populate rows. Is this possible with SQL? My understanding is that it is not possible but thought I'd ask anyway. Thanks

[SQL] DROP Column

Is DROP Column implemented in 7.x? Keith

[SQL] Is this feature a bug?

Greets folks. Put psql in html mode with \H execute a query. e.g.:- school=# \H Output format is html. school=# select timestamp('now'); timestamp 2001-01-31 11:24:21+13 (1 row) Is the "( 1 row)" string really supposed to be there? imho it should not be. How can I turn it

Re: [SQL] Archival of Live database to Historical database

Richard wrote: > > Hello everyone, > > I have hit on a limit in my knowledge and i am looking for > > some guidance. Currently I have two seperate databases, one for > > live data, the other for historical data. The only difference really > > being that the historical data has a Serial in it so th

[SQL] Getting Results From Trigger

Hello everyone, I was hoping someone could help me with this... I'm running postgres 7.02 on redhat 6.2, apache 1.3.14 and mod_perl 1.24_01. I'm also using perl modules DBI 1.14 and DBD-Pg-0.95 to acces the Postgres database. Everytime my inventory file gets updated, I would like to have the q

[SQL] binary operators

Hello, I am looking for the binary AND and OR ... SHIFT as well. Do they exist for postgresql ? Tanks, Fred

[SQL] Re: [HACKERS] How to modify type in table?

"Jaruwan Laongmal" wrote: >Would you like to inform me how to modify type in table? >For example , I define type as varchar(14) , but I want to modify to varcha= >r(120). How to do this. There is no facility to do this directly. (Allowing columns to change their type would possibly involve

[SQL] Hierarchical Queries

hi there, in the database i'm currently trying to implement i make heavy use of self joins and therefore i do often need to make hierarchical queries. oracle offers the connect by clause to do this. how can i do this with, postgresql? clemens

Re: [SQL] Archival of Live database to Historical database

From: "Stef Telford" <[EMAIL PROTECTED]> > Hello everyone, > I have hit on a limit in my knowledge and i am looking for > some guidance. Currently I have two seperate databases, one for > live data, the other for historical data. The only difference really > being that the historical data has a

Re: [SQL] script for unidirectional database update

From: "Markus Wagner" <[EMAIL PROTECTED]> > I need to periodically transfer the content of one db into another. The > target db should be deleted before and there should be one ascii file > containing the data, because there's a firewall between the two db's and > file transfer ist the most simp