The answer for you is Pl/Python3u. It can use numpy, which supports
infinite precision arithmetic and converting results to double and back.
It can also do linked lists. Depending on your age and your preferences,
you might try Pl/Perl. I learned Perl in 1993 and have never stopped
loving it. I
Dear pgsql-general,
I'm after Infinite Precision Integer (ii) or Infinite Precision Rational (ir)
type and function support for PostgreSQL, as an easy installation
for two new native types. That are available under free
and open source conditions, for public, private and commercial, free
use.
I
As suggested by David I would use Tablefunc.
This query should work.
select * from crosstab (
'select timestamp, name, value from originaltable',
'select distinct name from originaltable order by name'
)
as transposedtable (timestamp varchar, name1 varchar, name2 varchar, name3
varchar)
Rega
On Tue, Aug 17, 2021 at 11:29 AM Edu Gargiulo wrote:
>
> I need to transpose and return one row for a single timestamp and one
> column for every name (fixed number of names), something like this
>
>
https://www.postgresql.org/docs/current/tablefunc.html
or
select ..., max(value) filter (where
Hi all,
I got a view that returns values in the following format
timestamp | name |value
-
ts1name1 value11
ts1name2 value12
ts1name3 value13
ts2name1 value21
ts2name2
On Tue, Aug 17, 2021 at 4:34 PM Mladen Gogala wrote:
>
> You should locate Ora2Pg.pm using "find" like this:
>
> [mgogala@umajor ~]$ find /usr/local -name Ora2Pg.pm
> /usr/local/share/perl5/5.32/Ora2Pg.pm
Sounds like he is using strawberry Perl, that means he is on windows.
Things could be differ
On Tue, Aug 17, 2021 at 6:21 PM Michael White wrote:
> 1. PostgreSQL server is not started and I am having trouble figuring out how
> to start it because /Library/PostgreSQL/12 does not exist. (don’t know why)
that *could be* the reason why it does not start!
> 3. Don’t remember how I installe
This is my first post so if I’m in the wrong place please help me get to the
correct list.
Issue:
I installed PostgreSQL on my Mac over a year ago and since upgraded my disk
drive and OS to Big Sur. I am a retired Software Engineer and still like to
program and am learning PostgreSQL and have
You should locate Ora2Pg.pm using "find" like this:
[mgogala@umajor ~]$ find /usr/local -name Ora2Pg.pm
/usr/local/share/perl5/5.32/Ora2Pg.pm
[mgogala@umajor ~]$
and then make sure that your PERL5LIB directory contains the location:
export PERL5LIB=/usr/local/share/perl5/5.32:$PERL5LIB
That s
Hi all,
> If you want to update many rows after updating N rows,
Thanks to those who helped me with this - I think that Michael Lewis
has given me some good ideas on how I should go about this. Also,
thanks to those who took the time to explain why some of my ideas were
not well grounded (wouldn
yep we think this is exactly the issue...we have been testing a new
build with a later driver in UAT this morning and no recurrence of the
issue so looking most probable. thanks all for the very prompt and
clear responses it's most appreciated.
On Tue, 17 Aug 2021 at 13:09, Dave Cramer wrote:
>
>
Dave Cramer
www.postgres.rocks
On Mon, 16 Aug 2021 at 12:32, Andy Hall wrote:
> thanks for the very clear explanation much appreciated shall take this
> back to the team.
>
> On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote:
> >
> > Andy Hall writes:
> > > we have an odd issue where a java app us
Hello Team,
I am getting below error while executing export_schema.sh. Any suggestion/help
is really appreciated.
BEGIN failed--compilation aborted at /c/Strawberry/perl/site/bin/ora2pg line 27.
Can't locate Ora2Pg.pm in @INC (you may need to install the Ora2Pg module)
(@INC contains: /usr/lib/
13 matches
Mail list logo
