[SQL] User input in psql

2005-11-02 Thread Ashok Agrawal
Hi . Just wanted to know what is equivalent of "Oracle &" in postgresql. select count(*) from table1 where id =&1 where sqlplus plus will prompt to enter value for 1. I would like to do the same in psql. Thanks Ashok ---(end of broadcast)--- TIP

[SQL] date subtraction

2005-03-20 Thread Ashok Agrawal
I need to do date calculation similar to oracle in postgres. like sysdate - creation_date of the record which returns no of days in oracle which you can convert to hours or second by multiplying by 60 or 3600. How do i achieve this in postgres. Thanks Ashok ---(end of