Saturday September 10th, 2011

Listing all permissions in PostgreSQL

Filed under: Development, SQL — lars @ 09:40:33 am
I've just spent some time trying to debug a permissions issue in PostgreSQL that kept giving me the error "permission denied for <tablename>" when trying to access a view - even though I appeared to have all the required permissions… more »



Saturday July 11th, 2009

Grouping inner and outer joins

Filed under: TechNotes, Oracle, SQL — lars @ 07:32:55 pm
I was recently asked how to write a query that would contain a combination of inner and outer join (for Oracle).  In this case, the query was to return an entity and all it's attributes.  The entity needed to be returned even if there were no attr… more »



Monday March 30th, 2009

Oracle indexes tip

Filed under: TechNotes, Oracle, SQL — lars @ 05:41:51 am
I recently had the pleasure(?) of optimising a query in Oracle, and discovered that splitting the query into two parts, each returning part of the required results, and then creating indexes to optimise these seperately was a workable strategy.  in thi… more »



powered by  b2evolution