Re: [SQL] Determining the DATE format with libpq
От | Sebastien FLAESCH |
---|---|
Тема | Re: [SQL] Determining the DATE format with libpq |
Дата | |
Msg-id | a1236c41-584b-bbb1-b6ea-01d0dfffa000@4js.com обсуждение исходный текст |
Ответ на | Re: [SQL] Determining the DATE format with libpq (Sebastien FLAESCH <sf@4js.com>) |
Список | pgsql-sql |
I appologize for my poor English... I was just wondering about the overhead of a call to PQparameterStatus(). After some tests, it appears to be minor. Anyway, thanks for your help! Seb On 08/24/2017 05:44 PM, Sebastien FLAESCH wrote: > Whoooooo that's perfect!!! > > I hope it has not a big cost? > > Can I use this each time I fetch a result set? > > Even row by row with a server cursor? > > Seb > > On 08/24/2017 05:26 PM, Tom Lane wrote: >> Sebastien FLAESCH <sf@4js.com> writes: >>> Is there a way to know the current date format used in the SQL session? >>> Ideally, we expect a libpq API. >> >> Use PQparameterStatus(). >> >>> We cannot do a "SHOW DateStyle" each time we executing a SELECT! >> >> You don't have to --- the server automatically reports changes in the >> value of that parameter. >> >> regards, tom lane >> >> > > >
В списке pgsql-sql по дате отправления: