Skip site navigation (1) Skip section navigation (2)

Re: row-specific conditions possible?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: row-specific conditions possible?
Date: 2009-01-15 11:06:01
Message-ID: 20090115110601.GB22144@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-performance
In response to Jörg Kiegeland :
> Hi,

This list, [Perform], is obviously the wrong list for such...

> 
> I want to store a boolean SQL condition in a column "condition_column" 
> of my table "myTable".
> This condition refers to other columns of the same table and shall use 
> one parameter, e.g. "column1=4 AND colume2+column3=param".
> Every row has a different condition in general..

maybe this blog-entry can help you:
http://akretschmer.blogspot.com/2007/10/postgresql-formula-in-column-how.html


For further questions ask me privat.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

pgsql-performance by date

Next:From: Enrico WeigeltDate: 2009-01-15 18:34:16
Subject: Cost of INSERT rules
Previous:From: Jörg KiegelandDate: 2009-01-15 10:42:29
Subject: row-specific conditions possible?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group