Thanks for the extra feedback Merlin. I'll look into it a bit more,
JSONB obviously needs a bit of experimentation in the lab to get my
query syntax right !
On 27 January 2015 at 00:13, Merlin Moncure wrote:
> On Sun, Jan 25, 2015 at 6:50 AM, Tim Smith
> wrote:
>>> "Doesn't meet my particular u
> DISTINCT ON is my favorite lesser-known Postgres feature.
You said it ! There I was, trying and failing to make "DISTINCT" work
for me, little did I know that the little word ON was missing from my
Postgresql vocabulary !
Thanks !
On 27 January 2015 at 02:24, Maciek Sakrejda wrote:
> On Mon
Hi,
maybe this will help:
CREATE OR REPLACE FUNCTION _final_nth( anyarray, integer ) RETURNS
anyelement AS $BODY$ SELECT a FROM unnest( $1 ) a ORDER BY a offset $2
LIMIT 1; $BODY$
USE it without an extra aggregate-function.
SELECT _final_nth(array_agg(someelement),n) AS someelement FROM
so
Thanks for the tips. I'll make some adjustments
On Tue, Jan 27, 2015 at 8:38 PM, Sameer Kumar
wrote:
>
> On Tue, Jan 27, 2015 at 6:59 AM, Tim Uckun wrote:
>
>> The query seems to first use the timestamp column which results in a huge
>> number of records and then filters out using the integer a
Hi Guys,
I hope I'm in the right place to throw this. I just want to ask the reason
behind this weird scenario.
All records were deleted in a table even if the subquery in the where clause
has a missing a column.
--from a certain script where table_id is not yet existing on table_sample
delet
Hi list,
the system HDD of a server running postgresql 9.3 died (sudden
electronical death) during a pg_dump. The database is located on a
hardware raid system (another HDD). I installed a new ubuntu 14.04 with
postgresql 9.3 postgis 2.1. But i cannot start the server. First i got
the error:
Oliver Dizon wrote:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where table_id is not yet existin
Hi, there.
Firstly, as this is my first post on a PgSQL ML, I hope this ML is the
good one for my question.
I'm trying to secure further some PgSQL servers and am reading
documentation about libpq sslmode option. I have a question about that:
as I understand the internals of this option, the diff
Oliver Dizon schrieb am 27.01.2015 um 11:46:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where ta
On Tue, Jan 27, 2015 at 2:29 PM, David Guyot <
david.gu...@europecamions-interactive.com> wrote:
> Hi, there.
>
> Firstly, as this is my first post on a PgSQL ML, I hope this ML is the
> good one for my question.
>
> I'm trying to secure further some PgSQL servers and am reading
> documentation ab
Ah! So there was my error! Should be good to explain this in the
official libpq documentation, don't you think? If I correctly read, the
connection string as source of the hostname isn't explicit, there is
only the mention that libpq will check that the responding server is
“the one I specify”. Onc
Oliver Dizon writes:
> Hi Guys,
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
> --from a certain script where table_id is not ye
Sorry to ask again, but I still have not got any reply to this. Maybe this
indicates it’s a bad option?
>
>
> On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer
> mailto:jpal...@linz.govt.nz>> wrote:
>
> Hi All,
>
> I'm just investigating the option for configuring SSO for windows clients
> connect
Oliver Dizon writes:
> Hi Guys,
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
> --from a certain script where table_id is not ye
Oliver Dizon schrieb am 27.01.2015 um 11:46:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where ta
Hi:
I am wanting to define some functions as described in section 35.9 of
the manual, "C-Language Functions." I am compiling pre-existing files
of c-code from another project into object files, and then linking
those object files into a shared library along with my own functions
that follow the p
16 matches
Mail list logo
