On Mon, Feb 13, 2012 at 11:42 AM, wrote:
>
> Thank you very much. This is most helpful.
>
you're welcome. Keep in mind hstore features you need start with
postgres 9.0 and it's an extension aka contrib you have to add to the
database. (also as Andreas noted, please try to keep responses
on-lis
On Wed, Feb 8, 2012 at 10:51 AM, Andreas Kretschmer
wrote:
> mgo...@isstrucksoftware.net wrote:
>
>> We need to ensure that our data is in upper case only in the db. Is there a
>> easy way to do this via a function without having to name each column
>> separately?
>
> You can define a TRIGGER fo
mgo...@isstrucksoftware.net wrote:
> We need to ensure that our data is in upper case only in the db. Is there a
> easy way to do this via a function without having to name each column
> separately?
usually I like to explain why it's not possible before giving the game
away, but I see that ot
mgo...@isstrucksoftware.net wrote:
> Andres,
>
> Darn, I was hoping to not need to do one for each table. I was hoping that
> using %RowType might work.
1st, please answer to the list, not to me, okay?
2nd, please don't top-posting, quote below. It's hard to read
3rd, i understand your problem
mgo...@isstrucksoftware.net wrote:
> We need to ensure that our data is in upper case only in the db. Is there a
> easy way to do this via a function without having to name each column
> separately?
You can define a TRIGGER for such tasks (befor insert or update), but
you have to name each colu
<<< text/html; charset="utf-8": Unrecognized >>>
<>
