Re: [SQL] backup

Jyoti Seth wrote: Hi all, Can we take backup of specific data of a table (using where clause)? Thanks, Jyoti Try Selective COPY With Regards Ashish Karalkar EnterpriseDB -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

Re: [SQL] Exclude fields from SELECT command

no, there are no way regards Pavel Stehule Thanks for your time. Kind Regards Charles Workaround is create a view on that table excluding those 5 fields and then select * from that view . With regards Ashish Karalkar -- Sent via pgsql-sql mailing list (pgsql-sql

Re: [SQL] count question

5397 | 2 | 5397-02 >> 5409 | 3 | 5409-01 >> 5409 | 3 | 5409-02 >> 5409 | 3 | 5409-03 >> > > Shouldn't this function be the responsitibility of client software, > instead of database? > &g

Re: [SQL] foreign key problem

carg"? I apologize if it is a stupid question.... :-( many thanks to all Yes you can , check that column cod_carg of table generalita is not set to NOT NULL. With regards Ashish ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] How to use serial variable to insert into muiti-recrods?

I think default is a key word whic u r using as a column name in select statment. With Regards Ashish... - Original Message - From: "hu js" <[EMAIL PROTECTED]> To: Sent: Thursday, September 06, 2007 12:41 PM Subject: [SQL] How to use serial variable to insert in

Re: [SQL] List of FKeys ?

dtables || tablename||'.'||columnname|| ',' ; end if ; end loop; close curforeign ; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; Hope this will help With Regards Ashish ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[SQL] Birth Day Calculation

Hello All, I want to diplay all the name of persons who falls in between given day and month something like select name from my_table mt where mt.date_of_birth between 7-Jul and 15 - Aug column date_of_birth is of date type is there any way to do this Thanks in advance Ashish...

[SQL] Using case or if to return multiple rows

ate='x' Problem is that I have to do it in Plain SQL. Is there a anyway. Thanks in Advance With egards Ashish

[SQL] function to find difference between in days between two dates

ance With regards Ashish Karalkar

[SQL] sql server to postgreSQL

Hello All, I have a long list of sql server queries that needs to me remoulded in to postgres format can anyone please suggest me any tool that will convert sqlserver query into postgresql query except SwisSQL - SQLOne Console 3.0 Thanks in advance With regards Ashish Karalkar

Re: [SQL] need help

Anyone else is using this table simulteniously? With Regards Ashish... - Original Message - From: Penchalaiah P. To: pgsql-sql@postgresql.org Sent: Monday, May 14, 2007 12:20 PM Subject: [SQL] need help Hi . Create table cdano_nya(cdano int4,nyano int4

[SQL] Fetching BLOBs

fetching data. I am able to fetch the BLOB data from all cust servers but unfortunatelly it overwrite previous file. So pls provide any simple query format for the same, assuming two table tab1 & tab 2. Ashish . INDIA

[SQL] fetching & Merging BLOB

fetch the BLOB data from all cust servers but unfortunatelly it overwrite previous same name file instead of merging. So pls provide any simple query format for the same, assuming two table tab1 & tab 2. Ashish . INDIA

Re: [SQL] join and sort on 'best match'

& tab 2. Ashish . INDIA On 12/14/06, Markus Schaber <[EMAIL PROTECTED]> wrote: Hi, Ashish, "Ashish Ahlawat" <[EMAIL PROTECTED]> wrote: > hi pls tell me > > if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need > join ?

Re: [SQL] join and sort on 'best match'

hi pls tell me if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need join ??* *Ashish* On 12/13/06, Ragnar <[EMAIL PROTECTED]> wrote: On mið, 2006-12-13 at 10:26 +0100, Dirk Griffioen wrote: > I have been breaking my head on the following problem: how

Re: [SQL] Using Control Flow Functions in a SELECT Statement

, 'R', 's2'), ('View', 1, 'NR', 's1'), ('Show', 2, 'NR', 's2'), ('Amadeus', 1, 'PG', 's2') , ('Falcon', 1, 'NR', 's2'), ('Africa', 1, 'PG&#

[SQL] Using Control Flow Functions in a SELECT Statement

Hi Team I am unable to fetch data using following simple query it prompts following error *ORA: 00907: Missing right parenthesis* Query :- SELECT Name AS Title, StatID AS Status, RatingID AS Rating, IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verify FROM DVDs *Table Struct