Re: When should parameters be passed as text v. binary?

2020-01-04 Thread Paula Kirsch
enefit. my > gut tells me it will not add any benefiet > > > > On Sat, Jan 4, 2020 at 1:59 PM Andrew Gierth > wrote: > >> >>>>> "Paula" == Paula Kirsch writes: >> >> Paula> I'm just trying to understand the trade-offs betwe

When should parameters be passed as text v. binary?

2020-01-04 Thread Paula Kirsch
I'm just trying to understand the trade-offs between sending everything always as text, all integer parameters as binary, floats as binary, etc.

Question on the right way to think about order by

2018-07-03 Thread Paula Kirsch
When I think about using order by in a select statement, e.g. select id, name, price from stuff order by name; I think of order by as an operator sorting data returned by the select statement. When I think about order by in an aggregate statement, e.g. select string_agg(product, ' | ' order by