Postgres Pro
Downloads
Home   >   mailing lists

Re: hi sir urgent..required a Query - Mailing list pgsql-sql

From Josh Berkus
Subject Re: hi sir urgent..required a Query
Date
Msg-id 200404100816.40650.josh@agliodbs.com
Whole thread Raw
In response to hi sir urgent..required a Query  ("Rajeev Chaudhary, Noida" <rajeevc@noida.hcltech.com>)
List pgsql-sql
Tree view 
Rajeev,

> I am attaching a document with this file showing two table.. <<table_for_
> you.doc>>
>
> It consist of two table VALUE AND VALUE_TYPE..
>
> when i have value_type_id=1 i must get Value_varchar column value
>
> when i have value_type_id=2 i must get Value_int column value
> Please send a SQL query for this...

Please re-post this with your table design in the body of your e-mail, and NO 
doc attachment.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Counting rows from two tables in one query
Next
From: Josh Berkus
Date:
Subject: Re: setting a non-standard date format for the duration of a session