From: Beth Gatewood <bethg@mbt.washington.edu>
To: pgsql-sql@postgresql.org
Subject: trying to pattern match to a value contained in a column
Date: Thu, 07 Dec 2000 13:05:56 -0800
Message-ID: <3A2FFBB4.7B5156DA@mbt.washington.edu> (raw)
Hi-
I can't figure out how to do this....
I examine a table where I think that one attribute is an abbreviation of
another attribute.
So-If I had a table where I had LONG_NAME and ABBR as attributes.
I want something like
SELECT whatever FROM my_table WHERE long_name LIKE '%[the value of ABBR
in that row]%';
Of course this doesn't work...
Any thoughts?
Thanks-
Beth
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: bethg@mbt.washington.edu
Subject: Re: trying to pattern match to a value contained in a column
In-Reply-To: <3A2FFBB4.7B5156DA@mbt.washington.edu>
References: <3A2FFBB4.7B5156DA@mbt.washington.edu>
* 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