Hi all (and happy new year!) I'm a sequel noob and have been banging my head against a wall trying to get sequel to produce the following query:
SELECT *, COUNT(*) OVER() AS fullcount FROM "table" ... The "COUNT(*) OVER() AS fullcount" is a postgresism that allows one to get the total number of results ignoring a subsequent LIMIT; I need this for a pagination query. Anyone have any ideas? Thanks in advance Jim -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/IVCZFdNOOngJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
