On Feb 4, 2008 4:05 PM, John Siracusa <[EMAIL PROTECTED]> wrote:
> On Feb 4, 2008 3:51 PM, Grzegorz Nosek <[EMAIL PROTECTED]> wrote:
> > Functions taking rows as arguments may be used like extra table columns
> > only when qualified with a table alias.
>
> Can you use an alternate "normal" function call form as well?
>
> SELECT id, ..., is_even(...) FROM test;
>
> I'm not sure what'd go in (...), however. Anyway, is there a syntax
> form like that?
It looks like this works:
SELECT id, val1, val2, is_even(test) FROM test;
In which case you can try making a custom column type as per:
http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00710.html
...although I think it'll be kind of ugly since the table name will
need to appear in there. It's also not a flexible as having it "just
work" as a normal column specifier, so I'll see what I can do about
adding an option to unconditionally qualify columns in single-object,
single-table load() queries.
(still working on the column modification thing...)
-John
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
