El 11/11/17 a las 0:48, DrakoRod escribió:
Oh!!
Jose Maria TJ wrote
You're wrong, that are gcc versions, not OS versions.
For example in my CentOS 6 Box
cat /etc/redhat-release
CentOS release 6.9 (Final)
gcc -v
[...trimmed...]
gcc versión 4.4.7 20120313 (Red Hat 4.4.7-18) (GCC)
Y
I guess this is easy a question for the gurus, but afraid I cannot get
te answer!
I have this table:
aif_test=# \d sbox;
Table "public.sbox"
Column | Type | Modifiers
++---
id | character varying(255) | not null
data
Hi all,
I have a question about database design best pratice.
In my db I have about one hundred tables like this:
code
description
To avoid to have a so great number of similar tables in the db
I wonder if it is a good idea to unify all these tables in one big table
like this:
id
code
table_
Hi,
I made some changes to postgresql.conf and I want them to take effect
without having to restart the server.
I tried
select pg_reload_conf();
/usr/pgsql-9.1/bin/pg_ctl reload
but when I do 'show all', I see no changes take effect.
There settings I tried to change are:
-effective_cache_size
Thanks for your responses. Sorry, I forgot to mention that the query
actually takes 46 seconds despite what analyze (I dont quite understand the
output of explain). We did perform a vacuum last Friday and it seems to
help but not too much. We'll also try to recreate the indices.
Here's the output
I'm sorry my first example was incomplete
I need to migrate data from postgresql to oracle
thus I have to use
dump --column-inserts instead of copy
to have an output like this but order by pk:
INSERT INTO test (id, note, id_father) VALUES (6, 'Homer Simpson ', 5);
INSERT INTO test (id, note, id_f
Hello,
I have the following table and indices defined:
CREATE TABLE ticket
(
wid bigint NOT NULL DEFAULT nextval('tickets_id_seq'::regclass),
eid bigint,
created timestamp with time zone NOT NULL DEFAULT now(),
status integer NOT NULL DEFAULT 0,
argsxml text,
moduleid character varyin
lves my problem.
Thank you,
Jose
...
Jose Hales-Garcia
UCLA Department of Statistics
/usr/local/postgresql/pgsql-9.1.3/data -l /var/log/pgsql/pgsql-9.1.3/access.log
start
The lock files are in place:
/tmp/.s.PGSQL.5432
/tmp/.s.PGSQL.5432.lock
/tmp/.s.PGSQL.5433
/tmp/.s.PGSQL.5433.lock
I appreciate any help.
Sincerely,
Jose
...
Jose Hales-Garcia
UCLA Department of Statistics
Hi List,
This variable admit according to docs: mod, ddl, all values. the all
value is not accepted.
I have postgres 9.1.
s1=# set log_statement = all;
ERROR: syntax error at or near "all"
LINE 1: set log_statement = all;
cheers,
Jose
--
Sent via pgsql-general mailing list (pgs
On Fri, Jul 8, 2011 at 4:35 AM, Dean Rasheed wrote:
> > On Thu, 2011-07-07 at 15:34 +0200, vincent dephily wrote:
> >> Hi,
> >>
> >> I have a delete query taking 7.2G of ram (and counting) but I do not
> >> understant why so much memory is necessary. The server has 12G, and
> >> I'm afraid it'll g
El 08/08/10 21:49, Edoardo Panfili escribió:
On 08/08/10 20.47, Jose Maria Terry wrote:
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I&#x
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I've tried this that returns the min and max time in the desired range
for every logger, but i
which we hope it can connect to JASPA soon)
The authors of this project are:
Jose C. Martinez-Llario. Developer and project director. (1)
Marta Gonzalez-Alcaide. Tester and document builder. (1)
(1)Deparment of Cartographic Engineering, Geodesy and
Photogrammetry at La Universidad
I have PostgreSql 8.2.3
I need Windows 2008 Server support.
What version do you recommend which windows installer is the same kind as
version 8.2.3?
And where do I download it?
Not sure about how de C# driver you use to connect, but if you have
multiple connections, then you have multiple sessions.
2010/4/1 Sylvain Lara :
>> Hello,
>>
>> I found some subjects like mine on many forums, but the given solution
>> doesn't work for me.
>>
>> I'm using PostgreSQL 8.4. I'm work
Señores,
Saquen me de la lista ya no deceo resibir mas correos.
atte.
Jose Paredes Odar
Jòse
> From: r...@aarden.us
> To: r...@iol.ie
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] How to test my new install
> Date: Mon, 1 Feb 2010 04:48:08 -06
amp") ),remota,valor from historico
order by 1,2'
... changing quotes... but no luck.
Do anyone knows if i can't use that function or if i'm doing something bad?
Now i'm creating a temp table with timestamp "fixed"
Hi!
On Thu, Dec 3, 2009 at 10:39 PM, Jerome Alet wrote:
> On Thu, Dec 03, 2009 at 10:54:07AM +0800, Craig Ringer wrote:
>>
>> Anyway, it'd be nice if Bacula would convert file names to utf-8 at the
>> file daemon, using the encoding of the client, for storage in a utf-8
>> database.
>
> +1 for me
HI,
I want to get more information whether MVCC conflicts with manual locking ?
regards,
Jose Lawrence
Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
> itself open source, you have to pay to get a license. Pay for GPL software?
You cannot be serious, GPL has no relation with monetary value. The
GPL is a 'Usage License'. If i write GPL software to my clients,
should i give it free of charge ?. That's absurd.
--
Sent via pgsql-general mailin
Take a look at pgpool . http://pgpool.projects.postgresql.org/
2008/3/12, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> On Wed, 12 Mar 2008 09:13:14 -0700
> paul rivers <[EMAIL PROTECTED]> wrote:
>
> > For a database of InnoDB tables, people tend to replicate the
> > database, and then backup the
21 PM, Tom Lane wrote:
Jose Quiroz <[EMAIL PROTECTED]> writes:
2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la
relación 1663/17977/18281: Conseguido
Hmm, what PG version is that? This looks a bit like the results of
some
bugs that were fixed awhile ago.
I use the
The version of postgres is 8.1
And i don't have any backup of the system, I think that could be a
problem to restore the system.
thanks for answer.
regards, jose
On 01/02/2008, at 07:21 PM, Tom Lane wrote:
Jose Quiroz <[EMAIL PROTECTED]> writes:
2008-02-01 17:53:33 PET PA
rk, How I can restart the systema again?
Jose Quiroz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Bueno me pueden dar una mano para emigrar una bases
de dato de sql a posgres.
Slds
Ivan Rivera
Tel#(505)8074075
Managua, Nicaragua
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.e
456c48, 19c7, ce, 1) + 28
0005bd38 _bt_insertonpg (4273d8, 19c7, 455988, 1, 456c48, 455bd0) + db0
Rgds/
Jose Arteaga
-Original Message-
From: ARTEAGA Jose
Sent: Thursday, June 07, 2007 12:32 PM
To: Alvaro Herrera; Richard Huxton
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Li
why are you can make a good database relational server
as postgresql 8.1, and dont make a rad/ide open source
for programming with postgresql 8.1 as
delphi\c++builder\progress 4gl ?
thanks
___
Do Yo
to 1600 shared
buffers (~125MB). I've since noticed a dramatic performance improvement,
I hope that I've striked gold. But cannot claim victory yet it's only
been up for 2 days.
-Jose
-Original Message-----
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Thursday, June
x27;d just like to understand if maybe I'm running into some
sort of limit on the size of the database. My biggest table is currently
at 1.5B tuples.
Would appreciate if anyone could let me know or is aware of any limits
with 7.0 version.
Thx,
Jose
---(e
rue, does that mean the best CPU would be the last one, although the
> clock is lower that the one of the other processors?
>
> Thanks for the infos,
>
> Cheers,
>
> ---
> Philippe Lang
> Attik System
>
> ---(end of broadca
/Hello,
Oracle has a feature called "Virtual Private Databases" (VPD), that
enables you to configure permissions at row level. Is there an
equivalent feature in PostgreSQL?
Thank you,
jss
/
---(end of broadcast)---
TIP 9: In versions below 8
Buenas, queria saber como sacar la edad de alguien. Me da el siguiente error con el siguiente codigo :
-- Function: funcion_saca_edad()
DROP TRIGGER trigger_saca_edad ON fechas;
DROP FUNCTION funcion_saca_edad ();
CREATE OR REPLACE FUNCTION funcion_saca_edad() RETURNS OPAQUE AS'
DECLARE
ed
who
> has packed it for Debian, I will do it. Oh yes, - I am
> currently Co-Maintainer for some Packages in Debian.
>
> Greetings
> Michelle Konzack
> Systemadministrator
> Tamay Dogan Network
> Debian GNU/Linux Consultant
--
Juan Jose Comellas
Hola tengo un problema serio, my servidor de bases de datos se arruino y no saque copia de mi base de datos, he instalado otro servidor con las mismas caracteristicas pero como hago para recuperar toda la base de datos del anterior disco
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor
2005/8/24, Robert Treat <[EMAIL PROTECTED]>:
> On Wednesday 24 August 2005 03:50, Jose Gonzalez Gomez wrote:
> > Googling a bit I have discovered that what I probably need is an ETL
> > (extract, transform and load) tool, preferably open sourced and very
> > PostgreSQL
an ETL
(extract, transform and load) tool, preferably open sourced and very
PostgreSQL friendly... does anybody on this list have experience with
such kind of tools? Would anybody recommend anything? Maybe I could
try another approach?
Thanks in advance, best regards
Jose
---(e
On 6/19/05, Karl O. Pinc <[EMAIL PROTECTED]> wrote:
>
> On 06/19/2005 11:16:34 AM, Jose Gonzalez Gomez wrote:
> > On 6/17/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > > On Fri, Jun 17, 2005 at 14:35:01 +0200,
> > > Jose Gonzalez Gomez <[EMAIL P
On 6/17/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 17, 2005 at 14:35:01 +0200,
> Jose Gonzalez Gomez <[EMAIL PROTECTED]> wrote:
> >
> > The problem comes when you have questions that may be not applicable
> > (8), or optional (doesn&#
e a foreign
key referencing a view.
So the question is: can this be solved in an easy portable way? maybe
I should rethink the design so special values (not applicable /
optional) aren't represented the same way or in the same column that
real data?
Any thoughts are rea
Cuando subo la base de datos con pg_restore -d mydb < mydb.tar restablece toda la informacion pero los acentos y ñ muestran caracteres en otra codificacion como puedo solucionar esto__Correo Yahoo!Espacio para todos tus mensajes, antivirus y antispam
Using ODBC (unixODBC and iODBC) it is not possible to
retrieve or insert values from fields with a data type of int8 (int64_t in the
gcc compiler) when the operating system where the client is running is Linux.
(Slackware 9.0, 9.1, 10.0 or RH 9.0).
Any suggestion?
Thanks
Jose Mendoza
On august 2001 Eniar wrote above this issue the following:
“On Tue, Aug 07, 2001 at 07:49:06AM -0500, Phillip J. Allen wrote:> Hi all,> > I was reading Bruce Momjian book on PostgreSQL and his chapter on user> created functions stated that functions can be written in SQL, PL/PGSQL,> PL/
Alvaro,
Sorry, but, where are the log file and core you mentioned? I tried
/var/log/postgresql but is in 0 file size.
TIA
On Fri, Jul 02, 2004 at 07:36:50AM -0300, Juan Jose Costello Levien wrote:
I am writing my first trigger in C for PostgreSQL. It compiles Ok, and
added it to the
Hello,
I am trying to use a trigger function I wrote in C. Basically what I
want to do is to audit a table when a row is inserted into another table
by copying the row to the new table. It compiles Ok and I created a
shared library trigger.so. But when I load it into pgAdmin it tells me
'An err
owner of this view, is any
more in the database
but if I do select from table it works fine.
Is this a bug?
Jose
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unreg
Hi!
I have a doubt, I have somethigs same this...
init transaction
update from tabla1 set estado=1 where art=0;
update from tabla1 set estado=estado+1 where estado=1
final trasaction
The second update take the first updates if we are in the same transaction?
Tk
-
Hi all,
I need do a update from t1 set col='P' where int_art = (SELECT int_art from
t2 ).
I know that thios sentence is not correct but I'd like do the update for
everethigs rows that return the select.
Is it posible?
Tk very much
Jose Antonio
-Mensaje original-
e db query.
Does anyone have any idea how this can be done in PostgreSQL? Both Oracle and
DB2 support this with their own proprietary syntax.
--
Juan Jose Comellas
([EMAIL PROTECTED])
---(end of broadcast)---
TIP 2: you can get off all lists at onc
;AFAIK it's the only way to deal with that problem. Think
>about scaling as well. No enterprise class software has a DB
>connection per interactive user. They all have some sort of
>DB-middletear-presentation model where many users share a few
>DB connections.
>
Jose Soares
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
table WHERE field=value FOR UPDATE
at this point user2 can't do nothing except waiting for user1 unlock recors.
My question is:
- Is it possible to know in advance if the records of a given query are
locked, to prevent to be locked for ever?
Thank for any help,
J
Hi all,
I have a problem related with the maximum query length
ERR: query is too long. Maximum length is 16382
I'm using PostgreSQL 6.5.3 and python
Is this limit in the newer releases of PostgreSQL too?
Thanks for any help
Jose Soares
---(end of broa
Hello PG's,
I want to extract the weekday of a given 'date' type field in my table
when selecting. How can I do this?
For example in a table "bschft_days" filled with values with type 'date'
I want to select all the days within the month 'march' and output the respective
weekday. I tryed this:
Hello community,
anyone experienced problems using postgresql distribution
on SuSE 7.1 with reiserfs???
I noticed the following problem:
When creating a table 'tableA' as User A I can not insert in this
table with User A. The error message is always:
ERROR: tableA: Permission denied.
The on
Hello community,
I have a doubt about multiple access to a table in my database.
When two people are accessing the same table for insert or update,
is the affected row locked or am I supposed to lock this row explicit
in my application???
Any help will by welcome! :)
Best Regards / Un saludo /
Hello all!
I want to make a pg_dump of a database, but I must be sure that no one is
logged in. Which is the best way to do it?
Thanks in advance
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
-
Hello Tom,
Tom Lane wrote:
> Jose Manuel Lorenzo Lopez <[EMAIL PROTECTED]> writes:
> > I created a table bdf_users as admin user 'postgres' and granted insert
> > access for this table to public.
> > Now I want to insert a line as user 'jose'
Hello PG's,
I am trying to use the Perl module for Postgresql, but when I start
a simple example like this:
#!/usr/local/bin/perl -w
use Pg;
$conn = Pg::connectdb("dbname=template1");
die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
$result = $conn->exec("select tablename
Hello PG's,
I am trying to compile postgresql 7.0.3 on AIX 4.3.2.
Configure worked fine with ./configure --with-CC=/usr/local/bin/gcc
--without-CXX
but after that make break up very early with the following output:
Making postgres.imp
./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/
Hi :
I was using the wrong version(6.5.2) of pg_dump,that was
in
my PATH !!! With the correct version(7.0.2) the dump was
OK !!
Thanks !!
Claudio Grillo
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Claudio Grillo <[EMAIL PROTECTED]> writes:
> > getTables(): relation 'tb_bomb
Hello community,
I want to compile postgresql 7.0.3 on my WinNT at work, but I don't
know how! Am I supposed to compile it with VisualC++, as I read in
the docs I hope not, cause I am only a poor system admin!! :)
I have cygwin-tools on my machine so I hoped that's all I need!
Can anybody
I am trying to create a class for my application that handles
postgres access via the C interfaces.
My question is the following:
Will be PGresult also deleted when I close a connection with
PQfinish(PGconn), or am I supposed to delete the handle on
PGresult by myself after closing connection
It works fine for me ver 6.5.3.
Stefan Loidl ha scritto:
> Hi,
>
> I'm currently using postgres 6.4.2 on Sun Solaris.
> There seems to be a strange bug in the date_part() function.
> See below:
>
> accounting=> SELECT date_part('day','03-26-2000'::date);
> date_part
> -
>25
> (1
does, which I assume you are referring to. The problem is that
postgress doesn't echo anything for \commands only real SQL commands.
If it works on yours could you copy the echoed query and forward it
to me.
Jeff Seese
> From: Jose Soares <[EMAIL PROTECTED]>
; > select * from tmp where last='two'
> >
> > >ERROR: RestrictionClauseSensitivity: bad value -1.998613
> >
> > i tried to search the mailing lists but i couldn't find anything
> >
> > any ideas?
>
> It's working here with version 6.5.3. Which version are you using?
>
> Wim
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
need a datatype that can hold very
> large text?
>
> Chris
>
> --
> Christopher D. Gokey, Raytheon ITSS, NASA/GCMD
> 18 Martin Road, Shelburne Falls, MA 01370
> Phone: Voice (413) 625-8129 / FAX 208-248-9055
> [EMAIL PROTECTED] / http://gcmd.nasa.gov
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
ntation about how to do this,
and
the closest thing to an answer came from this newsgroup. No luck so
far
tho'
does anyone know how to do this and possibly and source of good
documentation on this type of thing.
Regards
Scott McDaid
edNET
t: +44 131 625 5557 (direct dial)
t: +44 131 466 7003 (office)
--
Jose' Soares
Bologna, Italy
[EMAIL PROTECTED]
>
> - Don Baccus, Portland OR <[EMAIL PROTECTED]>
> Nature photos, on-line guides, Pacific Northwest
> Rare Bird Alert Service and other goodies at
> http://donb.photo.net.
>
>
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
ansactions like PostgreSQL?
Tom Lane wrote:
> Jose Soares <[EMAIL PROTECTED]> writes:
> > ---
> > Interbase, Oracle,Informix,Solid,Ms-Access,DB2:
> > ---
> >
Dmitry Samersoff wrote:
> On 22-Feb-2000 Jose Soares wrote:
> > begin transaction;
> > create table tmp(a int);
> > insert into tmp values (1);
> > insert into tmp values (10);
> > ERROR: pg_atoi: error reading &q
s and who is in the rigth path
PostgreSQL or the others, considering the two examples reported below.
Comments?
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
txt);
return m;
end; ' language 'plpgsql';
Hitesh Patel wrote:
> Does anyone have a function laying around that convert a 'money' type to
> a float8 and return it?
>
>
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
A view is a table with a rule SELECT
For excample if you have a table named my_table
and you create a rule like:
CREATE RULE "_RETmy_table"
AS ON SELECT TO "my_table"
DO INSTEAD
SELECT * FROM your_table;
In this way you your table my_table
became a view.
José
Marc Tardif wrote:
> When lis
create table tablename ( field1 text, field2 text);
CREATE
insert into tablename values('bottom','yes');
INSERT 2282464 1
insert into tablename values('top','no');
INSERT 2282465 1
select field1,field2 from tablename order by (field1||'-top');
field1|field2
--+--
bottom|yes
top |no
(2 r
Peter Eisentraut wrote:
> On 2000-01-21, Bruce Momjian mentioned:
>
> > > Is there a way to use the max aggregate on an oid field? When I try on
> > > 6.5.3, I get the following error message:
> > >
> > > test=> select max(uid) from user_base;
> > > ERROR: Unable to select an aggregate function
Yury Don wrote:
Hello All,
I ma sorry, I have sent previous uncomplited e-mail accidentally.
I have created the table
CREATE TABLE "tt" (
"cc" int4);
COPY "tt" FROM stdin;
-2112563299
-2111287024
-2110307960
.
2146589610
2146589611
2146589612
\.
About 30 000 records totally
Then I a
"Hojdar Karel Ing." wrote:
> Hi,
>
> how I can get some agregates (avg, min, max) for whole week (in specified
> year)?
> For example from table with two columns : time datetime and value float8.
> And I want to get average of value based on whole weeks. If I try to use
> date_part('week',time)
I have some troubles to access PostgreSQL tables linked to M$-Access2000.
Does anyone have any ideas, how to do that?
Thanks.
[EMAIL PROTECTED] wrote:
> We've had good luck with something we found at:
>
> http://www.sevainc.com/
>
> David Boerwinkle
>
> -Original Message-
> From: Mike
I don't want to wait until
>things get very busy and then try to address these issues. We may
>decide we don't want to do anything, but I would like to decide that
>now.
I don't quite understand why you think that a license change is neaded.
One of the things that m
wrote:
>
> On 1999-12-16, Jose Soares mentioned:
>
> > I have a problem using \copy to load data into tables.
> >
> > I have to load data into a table that contains data type fields with
> > NULL values.
> > I tried using \N but it doesn't work.
> &g
1 row created.
SQL> select * from test;
ID I D
-- -- -
1 10 28-FEB-99
2 1.119 10-MAR-99
SQL> rollback;
Rollback complete.
SQL> select * from test;
ID I D
-- -- -
1 1
9
SQL> insert into TEST VALUES(1.999,'10-JAN-1999');
1 row created.
SQL> select * from test;
I D
-- -
10 28-FEB-99
1.999 10-JAN-99
SQL> rollback;
Rollback complete.
SQL> select * from test;
I D
-- -
10 28-FEB-99
Jose
select * from a;
a|b
-+-
1|primo
2|
(2 rows)
SELECT CASE WHEN b IS NOT NULL
THEN 'pref.'||b||'.suf'
ELSE 'pref.'||'NULL'||'.suf'
END FROM a;
case
--
pref.primo.suf
pref.NULL.suf
(2 rows)
Jose'
Sascha Ziemann wrote:
&qu
r at or near "value"
prova=> commit work;
END
prova=> select * from a;
ERROR: a: Table does not exist.
prova=>
Who are right. Oracle or PostgreSQL ?
Jose'
SQL function.
and CURRENT_TIMESTAMP is the exact SQL-92 syntax
Jose'
You must create a rule to make a view updatable as in the following
example:
drop table emp;
create table emp (
empno
int,
ename char(20),
job
char(12),
hiredate date,
sal
money,
comm
int,
deptno int,
level
oh! this was for old releases, now I'm using the following:
create function MsBool(bool,int4) returns bool as '
declare
bool_int int4;
begin
if $1 is NULL then
return NULL;
end if;
if $1 is TRUE then
if $2 <> 0 then
ret
description
--
a minha tabela
(1 row)
--
- Jose' -
"No other success in life can compensate for failure in the home" (David
O. McKay)
relationship in
> postgres?
>
> Thanks for any help.
Foreign key is not yet implemented but you may use triggers (See attached
example).
NB: You need v6.4.? to use examples.
--
- Jose' -
"No other success in life can compensate for failure in the home" (David
1;
end;
' language 'plpgsql';
CREATE
select text('12345678.2'::float8);
text
--
12345678.2
(1 row)
- Jose' -
And behold, I tell you these things that ye may learn wisdom; that
ye may
learn that when ye are in the service of your fellow beings ye
are only
in the service of your God.
- Mosiah 2:17 -
spanish and no sources),
you can download it from:
ftp://tlali.iztacala.unam.mx/pub/postgreSQL/hy4gl-inst.0.6.tgz
-Jose'-
Memphisto wrote:
>
> Hi,
>
> Is there a way to display big integer numbers splitted by periods in
> PostgreSQL queries?
>
> Example: 123.456.789 instead of 123456789 .
>
> Thanks in advance
You can create a function to format numbers.
S
Try:
select current_date, CURRENT_DATE - INTERVAL '1 DAY';
?column?|?column?
--+--
1999-01-08|1999-01-07 00:00:00+01
(1 row)
PostgreSQL has a syntax sligth different than SQL92. You have to enclose
'1 DAY' instead of '1' DAY
me how to catch then and deal with them?
>
That's mean that you had an error during transaction. The only command
that backend accepts at this point
is the END.
Jose'
C <---
4714-11--2147483624 BC <---
(2 rows)
Ooops! that seems like a bug.
prova=> select f from a;
f
1.7976931348623e+308
1.7976931348623e+308
(2 rows)
Jose'
Memphisto wrote:
>
> Hi,
>
> I'd like to know if there's an operator that conver
aster command line.
Another way to have this message should be compiling the parser
subdirectory
with -DPARSEDEBUG. (See the reply of Thomas G. Lockhart).
Jose'
ength|
+---+--+---+
| campo1| int4 not null| 4
|
+---+--+---+
Does someone knows what this message means ?
Thank you,
Jose'
tered.
>
> There must be a work-around, but I can not find any solution.
>
> thank you for your help
You may use doubble apostrophe as in O''Brian to match O'Brian this is
SQL92.
30|candy
NULL VALUES| | |
(5 rows)
SELECT name,NVL(salary)+100 AS dream FROM emp;
name |dream
---+-
Sam| 1300
Claire | 5100
Bill | 4300
Ginger | 4900
NULL VALUES| <--- I expected 100 here.
(5 rows)
On Tue, 9 Jun 1998, Mehrdad Ghassempoory wrote:
> I am trying to set up the table separator (Default "|") to TAB
> caharcter.
>
> I have tried :
>
> \f\t
> \f \t
> \f '\t'
>
> Without any luck.
> How is it done?
Try psql -F""
this mean ^I
Jose'
1 - 100 of 109 matches
Mail list logo
