Re: [SQL] Character type name?? How to lower case it? - Mailing list pgsql-sql

Moin!

On Fri, 29 Jan 1999 09:43:33 +0100 (MET)
    Remigiusz Sokolowski <rems@gdansk.sprint.pl> wrote:
> >
> > I have this script:
> >       SELECT a.attname, t.typname, a.attlen
> >         FROM pg_class c, pg_attribute a, pg_type t
> >           WHERE c.relname = 'regis' and a.attname in
> > ('var1','var2',var3');
> >
> > but a.attname is of type name, inwhich text(..) or lower(..)
> > do not work with this type and I do not seem to be able to
> > convert type name to text....
> >
> > Can someone help me get around this?
> >
>
> You could use case-insensitive regex operator - Your query should looks
> like following:
>     SELECT a.attname, t.typname, a.attlen
>         FROM pg_class c, pg_attribute a, pg_type t
>         WHERE c.relname = 'regis' and (a.attname ~*'var1' OR
> a.attname~*'var2' OR a.attname~*'var3');

Why not
[...]
  WHERE c.relname = 'regis' and a.attname ~* 'var[1-3]'
[...]

It's a regex, remember?
The OR isn't necessary.

HIH
 &
HAND
  Guido
--
Monday is an awful way to spend 1/7th of your life.