Re: Driver Postgresql HP-Unix
On 2023-10-21 21:13, Dave Cramer wrote: On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote: On 2023-10-19 04:45, Abelardo Erazo Lopez wrote: > Hi, Everyone > > I have an Oracle database Oracle 19c and I need to access a PostgreSQL > database 15.4 that resides on a different server. I see that one > alternative is to use ODBC from Oracle. However, the server where the > database resides is an HP-UX server and I understand that I need a > PostgreSQL driver manager compatible with this operating system. Can > you help me by indicating if there is one available, where to obtain > it, and if it requires a license? Any idea which version of HP-UX is running on that PostgreSQL server? Also, are you *sure* it's PostgreSQL 15.4, and not PostgreSQL 12.4? Asking because I'm not seeing version PG 15.4 in the list here, though PG 12.4 and 16 are: http://hpux.connect.org.uk/hppd/cgi-bin/search?term=postgresql I do not believe we publish the binaries for HP-UX but you should be able to build it. HP-UX doesn't seem to be among the build farm these days either, though there was a machine running it up until about ~500 days ago: https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=anole=HEAD + Justin
Presentation tools used ?
Hello All I am going to give a talk about PostgerSQL, so I'd like to ask you people what do you use for your presentations, also I have no idea how the remote control works to navigate through slides. I have seen it, but never came close to using one. I have access to google slides and libreoffice Impress. What tools would you suggest ? What's your setup ? Thank you! Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt
Re: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?
On 2023-10-19 00:12:51 -0400, Tom Lane wrote: > =?GBK?B?w6vDqw==?= writes: > > Do we have a rule by follow which one can accurately info the output of a > > SELECT statment FROM a table with floating-point data type? > > The goal of our floating-point output functions is to produce > the shortest representation from which the stored value could > be recovered exactly. It's not unusual for that to require > two or three decimal digits more than the nominal precision. To illustrate this: A real has 24 bits of mantissa. 12345.123456789 is between 2**13 and 2**14, so there are 10 bits left for the fraction. Or in other words, the number must be approximated as a multiple of 1/1024. The closest we can get is 12345+124/1024 = 12345.123046875 12345.123 would obviously be rounded to the same number, so it's close enough and additional digits aren't necessary. But 12345.12 would be rounded to 12345+123/1024 = 12345.1201171875. That's different, so 7 digits are not enough in this case. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at |-- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" signature.asc Description: PGP signature
Re: Driver Postgresql HP-Unix
On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote: > On 2023-10-19 04:45, Abelardo Erazo Lopez wrote: > > Hi, Everyone > > > > I have an Oracle database Oracle 19c and I need to access a PostgreSQL > > database 15.4 that resides on a different server. I see that one > > alternative is to use ODBC from Oracle. However, the server where the > > database resides is an HP-UX server and I understand that I need a > > PostgreSQL driver manager compatible with this operating system. Can > > you help me by indicating if there is one available, where to obtain > > it, and if it requires a license? > > Any idea which version of HP-UX is running on that PostgreSQL server? > > Also, are you *sure* it's PostgreSQL 15.4, and not PostgreSQL 12.4? > > Asking because I'm not seeing version PG 15.4 in the list here, though > PG 12.4 and 16 are: > >http://hpux.connect.org.uk/hppd/cgi-bin/search?term=postgresql I do not believe we publish the binaries for HP-UX but you should be able to build it. Dave
Re: Driver Postgresql HP-Unix
On 2023-10-19 04:45, Abelardo Erazo Lopez wrote: Hi, Everyone I have an Oracle database Oracle 19c and I need to access a PostgreSQL database 15.4 that resides on a different server. I see that one alternative is to use ODBC from Oracle. However, the server where the database resides is an HP-UX server and I understand that I need a PostgreSQL driver manager compatible with this operating system. Can you help me by indicating if there is one available, where to obtain it, and if it requires a license? Any idea which version of HP-UX is running on that PostgreSQL server? Also, are you *sure* it's PostgreSQL 15.4, and not PostgreSQL 12.4? Asking because I'm not seeing version PG 15.4 in the list here, though PG 12.4 and 16 are: http://hpux.connect.org.uk/hppd/cgi-bin/search?term=postgresql Regards and best wishes, Justin Clift