pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhelp!!!!!!!!!!!
36+ messages / 31 participants
[nested] [flat]
* help!!!!!!!!!!!
@ 1998-06-04 10:18 ATTILIO FERRARI PAWLIKOWSKI <a9213482@inform.pucp.edu.pe>
0 siblings, 0 replies; 36+ messages in thread
From: ATTILIO FERRARI PAWLIKOWSKI @ 1998-06-04 10:18 UTC (permalink / raw)
To: pgsql-sql
please, i'm developing a sw that use odbc postgresql, i need inmediately
information about how i make an updates and deletes in a sql
sentences,i'm using visual basic 4.0, and i'm trying with a execute
sentence and nohing happen.
thanks a lot
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 1998-06-24 21:03 Mariana Travassos Aguiar da Silva <travassos@e-net.com.br>
0 siblings, 0 replies; 36+ messages in thread
From: Mariana Travassos Aguiar da Silva @ 1998-06-24 21:03 UTC (permalink / raw)
To: pgsql-sql
How defines primary key, foreign key in postgresSql ?
Best Regarts, Mariana.
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 1999-03-09 18:39 Fernezelyi Marton <marci@c3.hu>
0 siblings, 0 replies; 36+ messages in thread
From: Fernezelyi Marton @ 1999-03-09 18:39 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 1999-03-31 15:58 Kaza <kaza@zaz.com.br>
0 siblings, 0 replies; 36+ messages in thread
From: Kaza @ 1999-03-31 15:58 UTC (permalink / raw)
To: pgsql-sql
PostgreSQl works with ref and setof. Thank you for the help.
Eduardo Jorge
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 1999-10-16 09:31 Ivanko Alexandr <slon@nikts.nk.ukrtel.net>
0 siblings, 0 replies; 36+ messages in thread
From: Ivanko Alexandr @ 1999-10-16 09:31 UTC (permalink / raw)
To: pgsql-sql@hub.org
help
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 1999-12-16 07:13 Rio <robertla@asiaep.com>
0 siblings, 0 replies; 36+ messages in thread
From: Rio @ 1999-12-16 07:13 UTC (permalink / raw)
To: pgsql-sql
I had installed postgresql 6.4.2 at solaris 7 on i386 machines . When i bring up the postmaster, it prompt a message "ld.so.1: postmaster: fatal: libncurses.so.4: open failed: No such file or directory". I did find for this libncurses.so.4 but there is no such file.
Anybody can give solution.
Thanks.
^ permalink raw reply [nested|flat] 36+ messages in thread
* help.
@ 2000-01-12 13:44 Alexandr Listopad <laa@zgia.zp.ua>
0 siblings, 0 replies; 36+ messages in thread
From: Alexandr Listopad @ 2000-01-12 13:44 UTC (permalink / raw)
To: pgsql-sql
hello!
How can I get an hour from decremented date (field)? Something like this
(don't work):
SELECT date_part('hour',('now' - 5)::datetime);
Thanks.
Regards,
Listopad Alexandr
(laa@zgia.zp.ua), LAA7-RIPE
ZGIA, Zaporozhye, Ukraine.
http://www.zgia.zp.ua.
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2001-03-07 18:18 chard <chard@hindang.msuiit.edu.ph>
0 siblings, 1 reply; 36+ messages in thread
From: chard @ 2001-03-07 18:18 UTC (permalink / raw)
To: pgsql-sql
help me pls.
i got an error like this when i do an insert to a table, my table dont
have bpchar type of field.
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2001-03-08 08:46 chard <chard@hindang.msuiit.edu.ph>
0 siblings, 1 reply; 36+ messages in thread
From: chard @ 2001-03-08 08:46 UTC (permalink / raw)
To: pgsql-sql
help me pls.
i got an error like this when i do an insert to a table, my table dont
have bpchar type of field.
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
it seems 1 field in my table has bpchar type, but if i view the table
definition all are varchar and numeric.
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2001-03-12 22:49 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: chard <chard@hindang.msuiit.edu.ph>
0 siblings, 0 replies; 36+ messages in thread
From: Stephan Szabo @ 2001-03-12 22:49 UTC (permalink / raw)
To: chard <chard@hindang.msuiit.edu.ph>; +Cc: pgsql-sql
What is the schema of the table in question, does it have any references
to other tables and what is an example insert statement?
On Wed, 7 Mar 2001, chard wrote:
>
> help me pls.
> i got an error like this when i do an insert to a table, my table dont
> have bpchar type of field.
>
> ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
> You will have to retype this query using an explicit cast
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2001-03-12 23:21 Tom Lane <tgl@sss.pgh.pa.us>
parent: chard <chard@hindang.msuiit.edu.ph>
0 siblings, 0 replies; 36+ messages in thread
From: Tom Lane @ 2001-03-12 23:21 UTC (permalink / raw)
To: chard <chard@hindang.msuiit.edu.ph>; +Cc: pgsql-sql
chard <chard@hindang.msuiit.edu.ph> writes:
> i got an error like this when i do an insert to a table, my table dont
> have bpchar type of field.
> ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
> You will have to retype this query using an explicit cast
> it seems 1 field in my table has bpchar type, but if i view the table
> definition all are varchar and numeric.
I'll bet you have a foreign-key constraint between a varchar field and
a bpchar field in another table.
regards, tom lane
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 2001-03-25 06:49 Mohamed ebrahim <mohdebrahim@yahoo.com>
0 siblings, 3 replies; 36+ messages in thread
From: Mohamed ebrahim @ 2001-03-25 06:49 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am a user postgresql. I want to update a table
automatically when we reach monthend. i.e i want to
update some table on 31 of every month automatically
without any user attention. I want to know how to do
this. If anyone knows how to do this please mail me. i
will be ever thankfull to him
Thank you
Ebrahim
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 2001-03-25 06:50 Mohamed ebrahim <mohdebrahim@yahoo.com>
0 siblings, 2 replies; 36+ messages in thread
From: Mohamed ebrahim @ 2001-03-25 06:50 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am a user of postgresql. I want to know that it
is possible to call a jsp file in postgre
command.Please help me to know how to call a jsp file.
Thank you
Ebrahim
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-25 19:37 Roberto Mello <rmello@cc.usu.edu>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
1 sibling, 0 replies; 36+ messages in thread
From: Roberto Mello @ 2001-03-25 19:37 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; +Cc: pgsql-sql
On Sat, Mar 24, 2001 at 10:50:31PM -0800, Mohamed ebrahim wrote:
> Hi,
>
> I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
You need a Servlet container to process jsp files and PostgreSQL does
not have a Java virtual machine. But you can use PostgreSQL from your Java
program by using JDBC.
Look for Jakarta/Tomcat for an open source servlet container.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-25 19:49 Brett W. McCoy <bmccoy@chapelperilous.net>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
1 sibling, 0 replies; 36+ messages in thread
From: Brett W. McCoy @ 2001-03-25 19:49 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; +Cc: pgsql-sql
On Sat, 24 Mar 2001, Mohamed ebrahim wrote:
> I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
What do you mean 'call a JSP file'? A JSP file is parsed and compiled by
something like Jasper or JServ and and is served through a web server like
Tomcat or Tomcat with Apache.
Now, you CAN use jdbc in JSP files and access PostgreSQL databases that
way. For that, you need to take a look at the jdbc documentation.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
There is no fear in love; but perfect love casteth out fear.
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-25 20:16 Joe Conway <jconway2@home.com>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
2 siblings, 1 reply; 36+ messages in thread
From: Joe Conway @ 2001-03-25 20:16 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; pgsql-sql
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows how to do this please mail me. i
> will be ever thankfull to him
Probably the easiest way to do this is to write a script and run it from
cron. For example, if your update query is in a file called
$HOME/bin/monthend.sql:
insert into mymonthendtable(f1, f2, f3)
values(123,'03/31/2001',12345.67);
your script (call it $HOME/bin/monthend.sh) might look like:
#!/bin/sh
psql -U postgres mydatabasename < $HOME/bin/monthend.sql
then run (see "man 5 crontab" for more on cron)
crontab -e
and add an entry like
# run at 2:15 AM on the 30th of every month
15 2 30 * * $HOME/bin/monthend.sh
Hope this helps,
Joe
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-25 20:21 Peter Eisentraut <peter_e@gmx.net>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
2 siblings, 0 replies; 36+ messages in thread
From: Peter Eisentraut @ 2001-03-25 20:21 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; +Cc: pgsql-sql
Mohamed ebrahim writes:
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention.
Use a cron job.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-25 20:23 Richard Huxton <dev@archonet.com>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
2 siblings, 0 replies; 36+ messages in thread
From: Richard Huxton @ 2001-03-25 20:23 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; pgsql-sql
From: "Mohamed ebrahim" <mohdebrahim@yahoo.com>
> Hi,
>
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows how to do this please mail me. i
> will be ever thankfull to him
I'm presuming that you are on some kind of unix-like system. If so, check
the "cron" system (man cron, man crontab) - use this to run a script at a
set time each month - the script can then update your database.
This can be as simple as placing a script into /etc/cron.monthly/ on some
systems (e.g. Linux Redhat) but in any case is not too complicated.
PS - it is usually easier to do this early on the first day of each month
(every month has a day 1, not all have a day 31).
- Richard Huxton
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 2001-03-26 07:36 Mohamed ebrahim <mohdebrahim@yahoo.com>
parent: Joe Conway <jconway2@home.com>
0 siblings, 1 reply; 36+ messages in thread
From: Mohamed ebrahim @ 2001-03-26 07:36 UTC (permalink / raw)
To: jconway2@home.com; pgsql-sql
Hi,
Thanks for your valuable information. I tried the
cron. i typed
cron -e
and entereed into the input area. but i don't know how
to save the cron file. I pressed ctrl+z and came out
from cron. but i edit the cron file i found nothing on
it.(i.e using pico filename.) Please tell me some
description how to save the file in cron and to achive
this. I will be thankful to you.
Ebrahim
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows how to do this please mail me.
>i
> will be ever thankfull to him.
>Joe wrote:
>
>Probably the easiest way to do this is to write a
>script and run it
>from
>cron. For example, if your update query is in a file
>called
>$HOME/bin/monthend.sql:
>
> insert into mymonthendtable(f1, f2, f3)
>values(123,'03/31/2001',12345.67);
>
>your script (call it $HOME/bin/monthend.sh) might
>look like:
>
> #!/bin/sh
> psql -U postgres mydatabasename <
>$HOME/bin/monthend.sql
>
>then run (see "man 5 crontab" for more on cron)
> crontab -e
>
>and add an entry like
>
> # run at 2:15 AM on the 30th of every month
> 15 2 30 * * $HOME/bin/monthend.sh
>
>Hope this helps,
>
>Joe
>
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-26 15:56 Joe Conway <jconway2@home.com>
parent: Mohamed ebrahim <mohdebrahim@yahoo.com>
0 siblings, 2 replies; 36+ messages in thread
From: Joe Conway @ 2001-03-26 15:56 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; pgsql-sql
> Thanks for your valuable information. I tried the
> cron. i typed
> cron -e
> and entereed into the input area. but i don't know how
> to save the cron file. I pressed ctrl+z and came out
> from cron. but i edit the cron file i found nothing on
> it.(i.e using pico filename.) Please tell me some
> description how to save the file in cron and to achive
> this. I will be thankful to you.
>
Instead of "ctrl+z", press ":wq" (colon for command mode, w for write, q for
quit). This assumes that vi is your default editor.
Joe
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-26 19:47 selkovjr@mcs.anl.gov
parent: Joe Conway <jconway2@home.com>
1 sibling, 0 replies; 36+ messages in thread
From: selkovjr@mcs.anl.gov @ 2001-03-26 19:47 UTC (permalink / raw)
To: Mohamed ebrahim <mohdebrahim@yahoo.com>; pgsql-sql
> Instead of "ctrl+z", press ":wq" (colon for command mode, w for write, q for
> quit).
If you are still mystified, "ctrl+z" stops a process running on a
terminal, so it's likely that your vi is still running idle. Type 'fg'
on the same terminal to bring it back. For more details on job
control, see 'info sh' and search for 'jobs'.
> This assumes that vi is your default editor.
Which you can change by setting your EDITOR environment variable.
For example, if your shell is bash,
export EDITOR="emacs -nw"
will do it.
--Gene
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: Help
@ 2001-03-26 20:38 Cedar Cox <cedarc@visionforisrael.com>
parent: Joe Conway <jconway2@home.com>
1 sibling, 0 replies; 36+ messages in thread
From: Cedar Cox @ 2001-03-26 20:38 UTC (permalink / raw)
To: Joe Conway <jconway2@home.com>; +Cc: Mohamed ebrahim <mohdebrahim@yahoo.com>; pgsql-sql
> > Thanks for your valuable information. I tried the
> > cron. i typed
> > cron -e
> > and entereed into the input area. but i don't know how
> > to save the cron file. I pressed ctrl+z and came out
> > from cron. but i edit the cron file i found nothing on
> > it.(i.e using pico filename.) Please tell me some
> > description how to save the file in cron and to achive
> > this. I will be thankful to you.
> >
>
> Instead of "ctrl+z", press ":wq" (colon for command mode, w for write, q for
> quit). This assumes that vi is your default editor.
>
And if you didn't know, you can set the VISUAL environment variable to
change your default editor. eg..
export VISUAL=pico
You can put this in your .profile to make it a default. Personally I
don't like line wrapping so I turn it off like this:
export VISUAL='pico -w'
You can also use the 'v' command in from 'less' to edit a file.. very
handy..
-Cedar
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2001-04-06 07:49 Loïc Bourgeois <loic.bourgeois@mobileway.com>
0 siblings, 0 replies; 36+ messages in thread
From: Loïc Bourgeois @ 2001-04-06 07:49 UTC (permalink / raw)
To: rmello@fslc.usu.edu; +Cc: pgsql-sql
I read your document about the porting from Oracle to PgSql and I would
like to know if
you can say to me if there is an equivalent on an the option NOWAIT for
a request
SELECT ... FOR UPDATE (for Oracle) under PgSql.
This option don't wait a previus unlock and return the information like
the line can't be lock.
Oracle:
SELECT * FROM toto WHERE id =4 and value = 'hello' FOR UPDATE NOWAIT;
PsSql:
????????????????????????
Tanks a lot....
^ permalink raw reply [nested|flat] 36+ messages in thread
* Help
@ 2002-09-10 08:29 =?iso-8859-2?Q?Bc._=A9imko_Juraj?= <dzimo@nextra.sk>
0 siblings, 0 replies; 36+ messages in thread
From: Bc. Šimko Juraj @ 2002-09-10 08:29 UTC (permalink / raw)
To: pgsql-sql
Hallo !
I have problem find out distribution of PostgreSQL for windows.
Can you help me, or send me some url links, where I will find it.
Thanks.
Juraj S,
----------------------------------------------------------------------------
---
Bc. Šimko Juraj
Juraja Kréna 6
915 01 Nové Mesto nad Váhom
Home: 032 7714271
Office: 032 7714281 kl. 246
GSM: 0903 100 173
Web: www.dzimo.sk
Email: dzimo@nextra.sk
^ permalink raw reply [nested|flat] 36+ messages in thread
* help!
@ 2002-10-16 09:15 John Geng <lanlz@sina.com>
0 siblings, 1 reply; 36+ messages in thread
From: John Geng @ 2002-10-16 09:15 UTC (permalink / raw)
To: pgsql-sql
how to migrate sql from MS sql server to postgresql?
i'd like to tranfer sql schema from MS server
Example:
*******************1*********************************
if exists (select * from sysobjects
where id = object_id(N'[admin].[test]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [admin].[test]
go
*******************2*********************************
CREATE TABLE [admin].[test] (
[test_name] [char] (50) NOT NULL ,
[test_value] [int] NOT NULL
)
i can only realize part 2. i don't know how to realize part 1.in other words,
i want to know how to check if a table exist in postgresql
*******************2*********************************
create table test(
test_name char (50) not null,
test_value int not null
)
thanks for any advice!!
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help!
@ 2002-10-19 00:22 Horst Herb <subscriptions@gnumed.net>
parent: John Geng <lanlz@sina.com>
0 siblings, 0 replies; 36+ messages in thread
From: Horst Herb @ 2002-10-19 00:22 UTC (permalink / raw)
To: John Geng <lanlz@sina.com>
On Wed, 16 Oct 2002 19:15, John Geng wrote:
> how to migrate sql from MS sql server to postgresql?
> i'd like to tranfer sql schema from MS server
> Example:
> *******************1*********************************
> if exists (select * from sysobjects
> where id = object_id(N'[admin].[test]') and
> OBJECTPROPERTY(id, N'IsUserTable') = 1)
> drop table [admin].[test]
if exists (select * from pg_tables where tablename = '<your table name goes
here')
might be what you are looking for
Horst
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2003-01-21 22:44 Rudi Starcevic <rudi@oasis.net.au>
0 siblings, 0 replies; 36+ messages in thread
From: Rudi Starcevic @ 2003-01-21 22:44 UTC (permalink / raw)
To: pgsql-sql
help
^ permalink raw reply [nested|flat] 36+ messages in thread
* HELP
@ 2003-04-16 10:28 rute solipa <rutes@eselx.ipl.pt>
0 siblings, 0 replies; 36+ messages in thread
From: rute solipa @ 2003-04-16 10:28 UTC (permalink / raw)
To: pgsql-sql
hi everyone, i realy need help.
does any one nows how to alter this oracle 9i query to postgresql.
select id_mensagem, ds_description,
e_mail, to_char(ds_date,'DD/MM/YY - HH24:MI'),
assunto, respondidas,
mensagem,
mensagens.id_resposta
from (select id_mensagem, ds_description,
e_mail, ds_date, assunto, mensagem,
id_resposta, RANK() OVER ( ORDER BY id_mensagem desc )as i
from tb_mensagens_monitores where tb_mensagens_monitores.id_resposta is null)
mensagens, (select id_resposta, count(id_mensagem) respondidas
from tb_mensagens_monitores group by id_resposta) respostas
where mensagens.id_mensagem = respostas.id_resposta(+)
and i <= 30 order by ds_date desc
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2003-06-12 14:15 Tony Simbine <jantos-work@mvweb.de>
0 siblings, 1 reply; 36+ messages in thread
From: Tony Simbine @ 2003-06-12 14:15 UTC (permalink / raw)
To: pgsql-sql
hello,
I've a query which needs too many time ca. 12-15 sec.
how can i get a better perfomance?
my table have less than 2300 rows.
thanks in advance
tony
explain select o.id from ioobeject o,dist_vertron v where
macro_lid=1123 and (o.id=v.id) and (o.deleted<>'1') and
(o.status='activo') order by o.ort;
QUERY
PLAN
---------------------------------------------------------------------------------------------------------------------------------
--------------
Sort (cost=790.49..791.63 rows=457 width=66)
Sort Key: o.ort
-> Hash Join (cost=228.88..770.31 rows=457 width=66)
Hash Cond: ("outer".id = "inner".id)
-> Append (cost=0.00..502.35 rows=3337 width=4)
-> Seq Scan on dist_vertron v (cost=0.00..0.00 rows=1
width=4)
-> Seq Scan on disposicao v (cost=0.00..136.87
rows=987 width=4)
-> Seq Scan on oponente v (cost=0.00..0.00 rows=1 width=4)
-> Seq Scan on novinho v (cost=0.00..5.14 rows=14 width=4)
-> Seq Scan on colagem_livre v (cost=0.00..194.69
rows=1369 width=4)
-> Seq Scan on jardim_contribuicao v
(cost=0.00..149.08 rows=808 width=4)
-> Seq Scan on jardim_comardia v (cost=0.00..16.57
rows=157 width=4)
-> Hash (cost=228.81..228.81 rows=27 width=62)
-> Append (cost=0.00..228.81 rows=27 width=62)
-> Seq Scan on ioobeject o (cost=0.00..0.00
rows=1 width=62)
Filter: ((macro_lid = 1123) AND (deleted <>
'1'::bpchar) AND (status = 'activo'::character varying))
-> Index Scan using iwohnung_macro_lid_index on
iwohnung o (cost=0.00..28.71 rows=3 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
izoologicowohnung_macro_lid_index on izoologicowohnung o
(cost=0.00..14.70 rows=1 width=19)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using icolagem_macro_lid_index on
icasamento o (cost=0.00..21.06 rows=2 width=18)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
iwohn_geschaefts_colagem_macro_lid__index on iwohn_geschaefts_casamento
o (cost=0.00..7.80 row
s=1 width=16)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
ialinhadocolagem_macro_lid_index on ialinhadocasamento o
(cost=0.00..8.30 rows=1 width=18)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
idobro_colagem_macro_lid_index on idobro_casamento o (cost=0.00..6.08
rows=1 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using ibauernhof_mediador_index on
ibauernhof o (cost=0.00..8.53 rows=1 width=18)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
imehrfamcolagem_mediador_index on imehrfamcasamento o (cost=0.00..11.49
rows=1 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
izoologicocolagem_macro_lid_index on izoologicocasamento o
(cost=0.00..8.03 rows=1 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
igartenbungalow_macro_lid_index on igartenbungalow o (cost=0.00..9.20
rows=1 width=19)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using iescritor_mediador_index on
iescritor o (cost=0.00..7.16 rows=1 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using ivilla_macro_lid_index on
ivilla o (cost=0.00..7.91 rows=1 width=16)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using igutscolagem_macro_lid_index
on igutscasamento o (cost=0.00..7.97 rows=1 width=18)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Seq Scan on ischloss o (cost=0.00..0.00
rows=1 width=62)
Filter: ((macro_lid = 1123) AND (deleted <>
'1'::bpchar) AND (status = 'activo'::character varying))
-> Seq Scan on isonstige o (cost=0.00..0.00
rows=1 width=62)
Filter: ((macro_lid = 1123) AND (deleted <>
'1'::bpchar) AND (status = 'activo'::character varying))
-> Index Scan using
idobro_casamentometade_macro_lid_index on idobro_casamentometade o
(cost=0.00..8.40 rows=1 wid
th=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using igrundstueck_macro_lid_index
on igrundstueck o (cost=0.00..17.02 rows=2 width=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using iloft_macro_lid_index on
iloft o (cost=0.00..5.99 rows=1 width=15)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using
ispezialimmobilie_macro_lid_index on ispezialimmobilie o
(cost=0.00..9.90 rows=1 width
=17)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using ilager_macro_lid_index on
ilager o (cost=0.00..16.50 rows=1 width=16)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using icomardiaraum_macro_lid_index
on icomardiaraum o (cost=0.00..8.51 rows=1 width=19)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
-> Index Scan using izimmer_macro_lid_index on
izimmer o (cost=0.00..15.55 rows=1 width=20)
Index Cond: (macro_lid = 1123)
Filter: ((deleted <> '1'::bpchar) AND
(status = 'activo'::character varying))
(80 rows)
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2003-06-12 17:10 Josh Berkus <josh@agliodbs.com>
parent: Tony Simbine <jantos-work@mvweb.de>
0 siblings, 1 reply; 36+ messages in thread
From: Josh Berkus @ 2003-06-12 17:10 UTC (permalink / raw)
To: Tony Simbine <jantos-work@mvweb.de>; pgsql-sql
Tony,
> I've a query which needs too many time ca. 12-15 sec.
> how can i get a better perfomance?
First of all, please take this to the PGSQL-PERFORMANCE list.
Second, see this web page:
http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines
> explain select o.id from ioobeject o,dist_vertron v where
> macro_lid=1123 and (o.id=v.id) and (o.deleted<>'1') and
> (o.status='activo') order by o.ort;
Third, from your explain, ioobject and dist_vertron are obviously somewhat
complex views. We need those view definitions, possibly plus schema for the
underlying tables (including indexes), or we can't help you.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2003-06-17 11:28 Tony Simbine <jantos-work@mvweb.de>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 36+ messages in thread
From: Tony Simbine @ 2003-06-17 11:28 UTC (permalink / raw)
To: pgsql-sql; +Cc: Josh Berkus <josh@agliodbs.com>
Josh,
thanks for your help.
Josh Berkus wrote:
> Tony,
>
>
>>I've a query which needs too many time ca. 12-15 sec.
>>how can i get a better perfomance?
>
>
> First of all, please take this to the PGSQL-PERFORMANCE list.
>
> Second, see this web page:
> http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines
i read some tips on the above pages and my database and all my
queries run very well.
i've optimized the queriey from where ... IN (select ..) to EXISTS
and I've done vacumdb full.
my requests last between 0.009 to 0.2 sec compared with 12-15 sec.
i'm very happy.
thanks very much.
tony
>
>
>>explain select o.id from ioobeject o,dist_vertron v where
>>macro_lid=1123 and (o.id=v.id) and (o.deleted<>'1') and
>>(o.status='activo') order by o.ort;
>
>
> Third, from your explain, ioobject and dist_vertron are obviously somewhat
> complex views. We need those view definitions, possibly plus schema for the
> underlying tables (including indexes), or we can't help you.
>
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2003-09-27 12:47 shengqj <shengqj@ics.ict.ac.cn>
0 siblings, 0 replies; 36+ messages in thread
From: shengqj @ 2003-09-27 12:47 UTC (permalink / raw)
To: pgsql-sql
Hi, there
I'm attempting to install PostgreSQL-7.3.3 under Windows 2000 professional.
-cygwin-1.5.5-1
-cygipc-2.01-2
but i got trouble when performing initdb command, all the interactive information listed as follows,
-------------------------------------------------
shengqj@babel ~
$ ipc-daemon2 &
[1] 4300
shengqj@babel ~
$ initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "shengqj".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /data/base... ok
creating directory /data/global... ok
creating directory /data/pg_xlog... ok
creating directory /data/pg_clog... ok
creating template1 database in /data/base/1...IpcSemaphoreCreate:semget(key=1,num=17,03600)failed: Function not
implemented
initdb failed.
Removing /usr/local/pgsql/data.
[1]+ Done. ipc-daemon2
shengqj@babel ~
---------------------------------------------------------------------
I have try many times, why?
Hope to get help.
Thanks!
Shengqj
shengqj@ics.ict.ac.cn
^ permalink raw reply [nested|flat] 36+ messages in thread
* help
@ 2010-05-05 03:05 Nicholas I <nicholas.domnic.i@gmail.com>
0 siblings, 2 replies; 36+ messages in thread
From: Nicholas I @ 2010-05-05 03:05 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the data which is only within the parentheses.
that is
1
2
3
Thank You
Nicholas I
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2010-05-07 15:24 Filip Rembiałkowski <plk.zuber@gmail.com>
parent: Nicholas I <nicholas.domnic.i@gmail.com>
1 sibling, 0 replies; 36+ messages in thread
From: Filip Rembiałkowski @ 2010-05-07 15:24 UTC (permalink / raw)
To: Nicholas I <nicholas.domnic.i@gmail.com>; +Cc: pgsql-sql
select substring( data from '\((.*)\)' ) from table;
2010/5/5 Nicholas I <nicholas.domnic.i@gmail.com>:
> Hi,
>
> I have a table in which the data's are entered like,
>
> Example:
>
> One (1)
> Two (2)
> Three (3)
>
> I want to extract the data which is only within the parentheses.
>
> that is
> 1
> 2
> 3
>
>
> Thank You
> Nicholas I
>
>
--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/
^ permalink raw reply [nested|flat] 36+ messages in thread
* Fw: Re: help
@ 2010-05-27 13:55 James Kitambara <jameskitambara@yahoo.co.uk>
0 siblings, 0 replies; 36+ messages in thread
From: James Kitambara @ 2010-05-27 13:55 UTC (permalink / raw)
To: Kenichiro Arakaki <inek883@gmail.com>; +Cc: pgsql-sql
--- On Thu, 27/5/10, James Kitambara <jameskitambara@yahoo.co.uk> wrote:
From: James Kitambara <jameskitambara@yahoo.co.uk>
Subject: Re: [SQL] help
To: "Nicholas I" <nicholas.domnic.i@gmail.com>
Date: Thursday, 27 May, 2010, 14:50
Hello Mr. Nicholas,
You can try the following:
THIS IS WHAT I TRIED TO SOLVE YOUR PROBLEM, BUT IN ORACLE DBMS
(SORRY I DON'T HAVE POSTGRESQL INSTALL ON MY COMPUTER)
i GUESS YOU CAN TRY TO CHANGE THE SQL COMMANDS IN POSTGRESQL
create table numbers (
id number not null primary key,
description varchar2(100)
);
insert into numbers values (300, 'Three hundred (300)');
insert into numbers values (350, 'Three hundred fifty (350)');
insert into numbers values (6709, 'Six thousand seven hundred and nine (6709)');
select id, description, substr(description, instr(description, '(') +1, instr(description, ')')-(instr(description, '(') +1)) extracted_character
from numbers;
This is the Results:
ID DESCRIPTION EXTRACTED_CHARACTERS
----------------------------------------------------------------------------------------------------------------
300 Three hundred 300
350 Tree hundred fifty 350
6709 Six thousand seven hundred and nine 6709
But if you run the following query you will get exactlly what:
select substr(description, instr(description, '(') +1, instr(description, ')')-(instr(description, '(') +1)) extracted_character
from numbers:
This is the Results:
EXTRACTED_CHARACTERS
-------------------------
300
350
6709
James Kitambara
B.Sc. With Computer Science and Statistics (Hons),
--- On Wed, 5/5/10, Nicholas I <nicholas.domnic.i@gmail.com> wrote:
From: Nicholas I <nicholas.domnic.i@gmail.com>
Subject: [SQL] help
To: pgsql-sql@postgresql.org
Date: Wednesday, 5 May, 2010, 4:05
Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the data which is only within the parentheses.
that is
1
2
3
Thank You
Nicholas I
^ permalink raw reply [nested|flat] 36+ messages in thread
* Re: help
@ 2010-06-28 06:46 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Nicholas I <nicholas.domnic.i@gmail.com>
1 sibling, 0 replies; 36+ messages in thread
From: Marcin Krawczyk @ 2010-06-28 06:46 UTC (permalink / raw)
To: Nicholas I <nicholas.domnic.i@gmail.com>; +Cc: pgsql-sql
Or even simpler, or easier to understand:
SELECT trim(foo, '()') FROM foobar
pozdrowienia / regards / salutations
mk
2010/5/5 Nicholas I <nicholas.domnic.i@gmail.com>
> Hi,
>
> I have a table in which the data's are entered like,
>
> Example:
>
> One (1)
> Two (2)
> Three (3)
>
> I want to extract the data which is only within the parentheses.
>
> that is
> 1
> 2
> 3
>
>
> Thank You
> Nicholas I
>
>
^ permalink raw reply [nested|flat] 36+ messages in thread
end of thread, other threads:[~2010-06-28 06:46 UTC | newest]
Thread overview: 36+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-04 10:18 help!!!!!!!!!!! ATTILIO FERRARI PAWLIKOWSKI <a9213482@inform.pucp.edu.pe>
1998-06-24 21:03 Help Mariana Travassos Aguiar da Silva <travassos@e-net.com.br>
1999-03-09 18:39 help Fernezelyi Marton <marci@c3.hu>
1999-03-31 15:58 Help Kaza <kaza@zaz.com.br>
1999-10-16 09:31 help Ivanko Alexandr <slon@nikts.nk.ukrtel.net>
1999-12-16 07:13 help Rio <robertla@asiaep.com>
2000-01-12 13:44 help. Alexandr Listopad <laa@zgia.zp.ua>
2001-03-07 18:18 help chard <chard@hindang.msuiit.edu.ph>
2001-03-12 22:49 ` Re: help Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-03-08 08:46 help chard <chard@hindang.msuiit.edu.ph>
2001-03-12 23:21 ` Re: help Tom Lane <tgl@sss.pgh.pa.us>
2001-03-25 06:49 Help Mohamed ebrahim <mohdebrahim@yahoo.com>
2001-03-25 20:16 ` Re: Help Joe Conway <jconway2@home.com>
2001-03-26 07:36 ` Help Mohamed ebrahim <mohdebrahim@yahoo.com>
2001-03-26 15:56 ` Re: Help Joe Conway <jconway2@home.com>
2001-03-26 19:47 ` Re: Help selkovjr@mcs.anl.gov
2001-03-26 20:38 ` Re: Help Cedar Cox <cedarc@visionforisrael.com>
2001-03-25 20:21 ` Re: Help Peter Eisentraut <peter_e@gmx.net>
2001-03-25 20:23 ` Re: Help Richard Huxton <dev@archonet.com>
2001-03-25 06:50 Help Mohamed ebrahim <mohdebrahim@yahoo.com>
2001-03-25 19:37 ` Re: Help Roberto Mello <rmello@cc.usu.edu>
2001-03-25 19:49 ` Re: Help Brett W. McCoy <bmccoy@chapelperilous.net>
2001-04-06 07:49 help Loïc Bourgeois <loic.bourgeois@mobileway.com>
2002-09-10 08:29 Help =?iso-8859-2?Q?Bc._=A9imko_Juraj?= <dzimo@nextra.sk>
2002-10-16 09:15 help! John Geng <lanlz@sina.com>
2002-10-19 00:22 ` Re: help! Horst Herb <subscriptions@gnumed.net>
2003-01-21 22:44 help Rudi Starcevic <rudi@oasis.net.au>
2003-04-16 10:28 HELP rute solipa <rutes@eselx.ipl.pt>
2003-06-12 14:15 help Tony Simbine <jantos-work@mvweb.de>
2003-06-12 17:10 ` Re: help Josh Berkus <josh@agliodbs.com>
2003-06-17 11:28 ` Re: help Tony Simbine <jantos-work@mvweb.de>
2003-09-27 12:47 help shengqj <shengqj@ics.ict.ac.cn>
2010-05-05 03:05 help Nicholas I <nicholas.domnic.i@gmail.com>
2010-05-07 15:24 ` Re: help Filip Rembiałkowski <plk.zuber@gmail.com>
2010-06-28 06:46 ` Re: help Marcin Krawczyk <jankes.mk@gmail.com>
2010-05-27 13:55 Fw: Re: help James Kitambara <jameskitambara@yahoo.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox