Re: Case Insensitive Data Type

From: grant <grant(at)amadensor(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Darren Ferguson <darren(at)crystalballinc(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case Insensitive Data Type
Date: 2002-05-24 22:02:20
Message-ID: Pine.LNX.4.33.0205241500580.4951-100000@dbms.amadensor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Would it be possible to make a view that simply returns a tolower() of the
field, then have an instead of trigger on the update of the view to
update the real table?

______________________________________________________________________________

Your mouse has moved.
You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-24 22:08:35 Re: Case Insensitive Data Type
Previous Message Johnson, Shaunn 2002-05-24 20:41:23 Re: problem with my function