recipe which sounds similar to your old approach here:
http://techspot.zzzeek.org/?p=31
On Feb 12, 2009, at 5:27 AM, Diez B. Roggisch wrote:
>
> Hi,
>
> with our old homegrown SQL-"wrapping" we enjoyed the possibility to
> time each
> sql-query to drill down on performance bottlenecks.
>
> T
On Mar 15, 2007, at 12:23 PM, Julien Cigar wrote:
> it returns something like:
> (u'freshwater', 33, 1983, u'Vascular plants', u'Lemna minuta',
> u'Minute
> duckweed')
> (u'terrestial', 39, 2006, u'Vascular plants', u'Lysichiton
> americanus',
> u'American skunk cabbage')
> (u'freshwater', 3
Hi Mike,
I tried with func.array() .. but I've still a problem.
At the moment I have the following:
j_name_lang = outerjoin(
table_invasive_names, table_languages,
table_invasive_names.c.language_id == table_languages.c.id
)
en_name = select(
[table_invasive_names.c.name,table_invas
use literal text (since its PG only anyway), or use func.ARRAY().
On Mar 15, 2007, at 11:16 AM, Julien Cigar wrote:
>
> Hello list,
>
> Any idea how I could generate this SQL statement under SQLAlchemy
> (especially the PostreSQL ARRAY clause ...) ?
>
> SELECT
> i.id,
> t.name AS taxo,
>
