efore running the playbook."
As I understand it ansible is just some deployment automation?
PostgreSQL is available as binaries and sources from a lot of places,
but Oracle is not, or am I missing something here?
Regards
Nicklas Avén
On Wed, 2017-09-20 at 09:44 +0200, Magnus Hagander wrote:
> On Wed, Sep 20, 2017 at 8:53 AM, Nicklas Avén g.no> wrote:
> > Hallo all
> >
> >
> >
> > I am thrilled about logical replication in PostgreSQL 10. My head
> > have
> >
> > started
include some way to check data integrity against
the original server with a md5 hash or something so result is identical
with the original.
ATB
Nicklas Avén
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
ht type at once) it works as
expected.
two questions:
1) is this a bug
2) is there a way to "cean" the table from the deleted columns without
recreating it?
Best Regards
Nicklas Avén
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
I use php and pg_unescape_bytea
http://php.net/manual/en/function.pg-unescape-bytea.php
You also need to set bytea format to escaped in front of your query.
If php can be en option
/Nicklas Avén
Skickat från min Samsung Mobil.
Originalmeddelande Från: Jov
Datum:2014
blank lines is removed in general since I cannot read
csv-files with blank lines, and I do not understand how the option
"force_not_null" can do the trick since that is on the column level and not
lines/row.
Any good ideas out there?
Thanks
Nicklas Avén
Thank you Tom
On 05/19/2013 01:26 AM, Tom Lane wrote:
=?UTF-8?B?Tmlja2xhcyBBdsOpbg==?= writes:
Perhaps you could construct your usage like this:
post_process_function(aggregate_function(...), fixed_argument)
where the aggregate_function just collects the varying values
and then the p
st Regards
Nicklas Avén
an be
copied without cost is shared without cost.
But so fare there is no technology to copy the hardware, server rooms,
internet bandwidth and so on for no cost.
Regards
Nicklas Avén
On Sat, 2011-08-06 at 15:49 +0200, Fernando Pianegiani wrote:
> Thak you Antonio.
>
> After open
One way to get around the problem is often to do a left or right join,
use = instead of <> , and catch the rows with null in id field,
something like:
SELECT a.* from
table a LEFT JOIN tableb b on a.testfld=b.testfld
WHERE b.id is null;
This one will use indexes on testflda and testfldb an
HTH
nge then was that PostGIS functions marked immutable also
was recalculated between Select and where-clause and also if used
multiple times in the Select part.
But I think (from very few tests) that the result of the function was
reused in a better way now.
Can that be the case?
Thanks
Nicklas A
ses ?
>
> |What version of PostGIS are you using?
>
> 1.5.1
>
>
> 2011/1/13 Nicklas Avén
> Hallo Håvard
>
> The planner is supposed to take care of that. It estimates
> ehat is the
> cheapest part of the OR
spect, and that is why I have to apologize because my answer
yesterday was not respectful. It was more like an instinctive reaction.
So to Adarsh Sharma, I am sorry and I apologize
Regards
Nicklas Avén
On Mon, 2011-01-03 at 13:47 +0100, Nicklas Avén wrote:
> Happy new year
> but spare
Happy new year
but spare me from any blessings, please
/Nicklas
2011-01-03 skrev Adarsh Sharma :
Dear all,
>
>
>A very-very Happy New Year 2011 to all. May God Bless all of us to solve
>future problems.
>
>
>Thanks and Regards
>
>Adarsh Sharma
>
>
>
>--
>Sent via pgsql-general mailing list (pg
Hallo
This I think should work.
To get the usernames by hour as you describe:
SELECT h.hour, usrlog.userid
(select generate_series(1,24) as hour) as h
inner join
usrlog
on h.hour >= usrlog.loginhr and h.hour <= usrlog.logouthr
order by h.hour, usrlog.userid;
To get the number of users per hour
If you want to use the boolean approach I would just (as suggested earlier)
cast to integer and sum. Like:
SELECT
sum(good::int) as good,
count(good)-sum(good::int) as "not good"
and so on
I thing the boolean approach seems reasonable if good, nice and fair is three
separaty judgements as I und
16 matches
Mail list logo
