select without from

22 views
Skip to first unread message

Daniel

unread,
Nov 13, 2014, 4:01:44 PM11/13/14
to squ...@googlegroups.com
As part of a locking table, I'm trying to execute:

select now(); 

in Postgres in order to use the DB as a synchronized time source. I can't figure out from the docs or examples a way to create a select statement without a table. Is this supported? Is there something simple I'm missing?

David Whittaker

unread,
Nov 13, 2014, 6:09:46 PM11/13/14
to squ...@googlegroups.com
I can't think of a way to do this with Squeryl, but I also can't see how Squeryl would help much with a query like this.  Squeryl's strength is in maintaining type safety when your SQL maps to Scala objects.  Since that's not the case here, you're probably better off just using straight JDBC.

--
You received this message because you are subscribed to the Google Groups "Squeryl" group.
To unsubscribe from this group and stop receiving emails from it, send an email to squeryl+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages