Re: [SQL] Converting from MS Access field aliases

* Tom Lane <[EMAIL PROTECTED]> wrote: Hi, > This is not an "extension", it is *directly* contrary to both > the letter and spirit of the SQL standard. at which point is this breaking the specification ? What would happen if postgres would allow this ? IMHO supporting aliases in where clauses

[SQL] Implementing an regex filter

Hi folks, I've coded an auction crawler, which queries several auction platforms for user-defined keywords. The results are then put into queues an sorted out from there. For example each auction query can be passed along with an maxprice value, which is put into the result records. Every few

[SQL] Performance on writable views

Hi folks, I'm often using writable views as interfaces to clients, so they only see "virtual" objects and never have to cope with the actual storage, ie. to give some client an totally denormalized view of certain things, containing only those information required for certain kind of operatio

Re: [SQL] Database synchronization

* Jyoti Seth <[EMAIL PROTECTED]> wrote: Hi, if you can live with some seconds lag, you can use an separate transfer process which looks at the source of your prices and and updates the second DB if some price changes. Depending on how often prices change, there're two good options: a) add an

Re: [SQL] Implementing an regex filter

Enrico Weigelt wrote: Hi folks, Any hints for futher optimization appreciated :) thx It doesn't look like you have any indexes - I'd add one to at least articles.title and blacklist.title to start with and probably also user_results.article_id and articles.inode_id. -- Paul Lambert Dat