pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Rajeev Chaudhary, Noida <rajeevc@noida.hcltech.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: hi sir urgent..required a Query
Date: Sat, 10 Apr 2004 08:16:40 -0700
Message-ID: <200404100816.40650.josh@agliodbs.com> (raw)
In-Reply-To: <1B3885BC15C7024C845AAC78314766C583DC42@exch-01.noida.hcltech.com>
References: <1B3885BC15C7024C845AAC78314766C583DC42@exch-01.noida.hcltech.com>

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



view thread (2+ messages)

Message-ID: <200404100816.40650.josh@agliodbs.com>
Permalink:  ../200404100816.40650.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200404100816.40650.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, rajeevc@noida.hcltech.com
  Subject: Re: hi sir urgent..required a Query
  In-Reply-To: <200404100816.40650.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox