.bz2
different (and not compile ) compared to the git tag REL_10_0 distribution that
does compile?
Thanks,
Andre Mikulec
andre_miku...@hotmail.com
---
However in my case,
I have this adjustement
"case when measure > 0.00 then 0.00 else measure end"
So the case seems that I need access to 'X'
but access to sumX and sumX2 are only shown.
How would I get accress to X?
May anyone point me to a simple good work
more powerful Language distributions
( other than the ones that were mentioned earlier )
Activestate TCL
ACTIVETCL COMMUNITY EDITION DOWNLOAD
http://www.activestate.com/activetcl/downloads
Strawberry Perl
http://strawberryperl.com/
WinPython
https://winpython.github.io/
Andre Mikulec
andre_miku...@hotmail.com
May strait answer is true.
1. I need to change the width of all of my tables because I have very wide
data. There is a compile-time parameter for that.
2. I need to debug, compile and install a modified version of the PostgreSQL
extension pl/r.
Andre Mikulec
andre_miku...@hotmail.com
Never mind. I figured it out.
Soon I will write up a summary.
Andre Mikulec
andre_miku...@hotmail.com
From: Andre Mikulec
Sent: Sunday, October 23, 2016 7:05 PM
To: pgsql-general@postgresql.org
Cc: Tom Lane
Subject: Re: [GENERAL] configure PostgreSQL with
Never mind. I figured it out.
Soon, I will write up a summary.
Andre Mikulec
andre_miku...@hotmail.com
From: Adrian Klaver
Sent: Sunday, October 23, 2016 7:18 PM
To: Andre Mikulec; pgsql-general@postgresql.org
Cc: Tom Lane
Subject: Re: [GENERAL] configure
src\interfaces\libpq/fe-misc.c:603: undefined
reference to `win32_htonl'
collect2.exe: error: ld returned 1 exit status
make[3]: *** [libpq.dll] Error 1
make[3]: Leaving directory
`/c/postgres-master_0ab9c56_debug/src/interfaces/libpq'
make[2]: *** [all-libpq-recurse] Error 2
make
$
if {$1 > $2} {return $1}
return $2
$$ LANGUAGE pltcl STRICT;
select tcl_max(5,3);
postgres=# select tcl_max(5,3);
tcl_max
-
5
(1 row)
Thanks,
Andre Mikulec
andre_miku...@hotmail.com
____
From: Tom Lane
Sent: Thursday, October 20, 2016 10:18
postgresql.org/docs/9.5/static/plpython-funcs.html
Last, I did a very simple test.
postgres=# select pymax(5,3);
pymax
---
5
(1 row)
Thanks,
Andre Mikulec
andre_miku...@hotmail.com
From: Tom Lane
Sent: Thursday, October 20, 2016 10:03 AM
To: A
Adrian,
I am sorry. I am not trying to use the Language Packs, to build my own custom
version of a Language. I mispoke myself.
Thanks,
Andre Mikulec
andre_miku...@hotmail.com
From: Adrian Klaver
Sent: Thursday, October 20, 2016 9:58 AM
To: Andre Mikulec
Tom,
I m getting this.
TargetUser@TARGETMACH ~
$ perl -v
This is perl, v5.8.8 built for msys-64int
5.8.8 is not right. See later emails.
Andre Mikulec
andre_miku...@hotmail.com
From: Tom Lane
Sent: Thursday, October 20, 2016 9:54 AM
To: Andre Mikulec
Cc
c/pl/tcl'
make[2]: *** [all-tcl-recurse] Error 2
make[2]: Leaving directory `/c/postgres-master_0ab9c56_debug/src/pl'
make[1]: *** [all-pl-recurse] Error 2
make[1]: Leaving directory `/c/postgres-master_0ab9c56_debug/src'
make: *** [all-src-recurse] Error 2
I do not know what to do next.
Please help.
Thank you,
Andre Mikulec
andre_miku...@hotmail.com
is ."?
I do not know what to do next.
Please help.
Thank you,
Andre Mikulec
andre_miku...@hotmail.com
n 5 2016, 16:11:51) [MSC v.1800 64 bit (AMD64)] on w
32
Type "help", "copyright", "credits" or "license" for more information.
>>> import distutils
>>>
Please help.
Thank you.
Andre Mikulec
andre_miku...@hotmail.com
Hi all,
I don't know how to ask for this. I need to rotate a Select in
PostgreSql, just like this: http://dpaste.com/1021691/
I can achieve this easily without a procedure?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Hi,
I've developed a system that was not to work online, but now it is
online and it is degrading due to bad design choices.
Here is the thing. I've the database build in "vertical mode". I will
justo explain what I mean with that.
Attribute | Value
site_name | Some site name1
uri
Hi,
I need to do an operation that I will use some SELECT's and get the
results, but I want to have sure that those tables have not been
changed with INSERT's or UPDATES during the operation.
Example:
BEGIN OPERATION
Select field from table1;
...
Select other_field from table2;
...
END OPERATION
Hi,
I'm writing a web application that uses PostgreSQL and I need to do
some operations where I read/write to 3 tables in the same
transaction. To do this I need to store the values of variables and
I'm not sure if it is possible to do this without using plPgSQL.
[code]
SELECT count(email) INTO v
Hi all,
I'm designing an application in Python and using PostgreSQL.
This is a mixed question Python/PostgreSQL... I need to get a signal
in my python application when a new insert is done. How can this be
done, any clues?
Best Regards,
André
--
Sent via pgsql-general mailing list (pgsql-gene
Hi all,
I need to create a table to store Twitter accounts information,
Facebook and other social networks details for API login. I need to
know if it is possible to store the account details("account_details"
field) in a field that contains something like an array. I need to
store this data in an
Hi all,
To do this backup remotely we need to open the 5434 port in the Firewall?
Best Regards,
On Mon, Feb 6, 2012 at 5:28 PM, Andreas Kretschmer
wrote:
> Fanbin Meng wrote:
>
>> I installed the PostgreSql9.0 in windows 7 with "one click installer".
>> How can i backup another PostgreSql ser
Thanks for your help. It is working.
Best Regards,
On Wed, Dec 21, 2011 at 9:04 PM, Bill Moran wrote:
> In response to Andre Lopes :
>
>> Hi,
>>
>> I need to escape quotes on an insert into that have a quote like this:
>>
>> http://host.com/cond'nast
Hi,
I need to escape quotes on an insert into that have a quote like this:
http://host.com/cond'nast
How can I escape " ' " on an insert into?
Best Regards,
André.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
Hi,
I'm using PostgreSQL 8.3 and I need to reduce the timeout. How can I
configure the connection timeout?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
9:52 AM, John R Pierce wrote:
> On 12/07/11 1:27 AM, Andre Lopes wrote:
>>
>> This is enough information for some clues on how to increase the
>> response time in queries?
>
>
> no.
>
> to optimize queries, you generally need to know what the queries are, what
&g
Hi,
I have a "vertical" database schema running with an webapp. I query
this database in the webapp rotating the vertical schema with a
view(something like a pivot view)
I know that this type of operation is very expensive, but I have the
webapp running with acceptable response time for 45 days(m
Hi John,
Thanks for the replies.
The problem was the ident in the host. Problem solved.
Thanks a lot!
Best Regards,
On Fri, Dec 2, 2011 at 11:46 PM, John R Pierce wrote:
> On 12/02/11 3:41 PM, Andre Lopes wrote:
>>
>> My pg_hba.conf have this:
>> [code]
>> #
, December 02, 2011 3:13:41 pm Andre Lopes wrote:
>> Hi,
>>
>> I've installed PostgreSQL 9.0 in CentOS6 I don't have configured
>> anything in Postgre, I just created a user with this method:
>>
>
>>
>> With the method above I have no problems in
Hi,
I've installed PostgreSQL 9.0 in CentOS6 I don't have configured
anything in Postgre, I just created a user with this method:
[article]
Here is how I do to create a Postgres user with the same username as
my regular login in Linux Ubuntu.
Go to your terminal with your regular user and do:
{
his?
Best Regards,
On Tue, Oct 18, 2011 at 9:08 AM, Craig Ringer wrote:
> On 10/18/2011 03:52 PM, Andre Lopes wrote:
>>
>> Hi,
>>
>> I have created a database that have a function that disable triggers
>> on tables, but when I execute the function: (I have created
Hi,
I have created a database that have a function that disable triggers
on tables, but when I execute the function: (I have created the
database with the same user that I'm trying to execute the function)
[code]
select triggerall(false);
[/code]
return
[code]
ERROR: permission denied: "RI_Con
Thanks for the reply. I have installed with the user "postgres" and it
worked. Thanks!
2011/8/17 Adrian Klaver :
> On Wednesday, August 17, 2011 6:44:31 am Andre Lopes wrote:
>> I have installed and tried to import the SQL, but I got this:
>>
>> [code]
>>
I have installed and tried to import the SQL, but I got this:
[code]
[andre@andre public]$ psql -d 420 -f /usr/pgsql-9.0/share/contrib/pgcrypto.sql
SET
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:9: ERROR: permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:14
Hi,
I am using CentOS and PostgreSQL9. I have an application that uses
Pgcrypto. I have googled but I am not sure how can I install this in
PostgreSQL9.
Someone can give me a clue on this?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
Does anyone know of a document comparing SQLite and PostgreSQL ?
Thanks in advance.
--
André Majorel http://www.teaser.fr/~amajorel/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Suppose you want to write a program that connects to a
PostgreSQL database and lists its tables and views, the type of
their columns and their relationships (REFERENCES) for automatic
joins.
Would you look at the system tables (pg_class et al.) or the
output of psql \d, \dt, etc ?
While parsing t
Hi,
I'm willing to contact a PostgreSQL developer working in Holland. I
know that this is not the main reason of this list.
Please contact-me by e-mail.
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
Hi,
I'm using a bytea field to store small images in base64. I need to
know if I can compare bytea rows for equality. To know for example if
the file already exists in the database, this is possible with bytea?
Best Regads,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
;
> for one dimensional arrays - select array_upper(var,1) - array_lower(var,1)
>
> Regards
>
> Pavel Stehule
>
> 2011/3/6 Andre Lopes :
>> Hi,
>>
>> Just another question about this subject.
>>
>> It is possible to compare if these 3 PlpgSQL arrays ha
,html_width_height,mime}
NOTICE: values: {jpg,343,515,"width=\"343\" height=\"515\"",image/jpeg}
Best Regards,
On Sat, Mar 5, 2011 at 10:44 PM, John R Pierce wrote:
> On 03/05/11 11:22 AM, Andre Lopes wrote:
>>
>> Hi,
>>
>> I need to transform a
Thanks again,
I saw this tutorial on how to get Key => Value,
http://justatheory.com/computers/databases/postgresql/key-value-pairs.html
It is not possible to use hstore to me.
Best Regards,
On Sat, Mar 5, 2011 at 7:42 PM, Pavel Stehule wrote:
> 2011/3/5 Andre Lopes :
>&
string_to_array function
>
> SELECT func(string_to_array('1,2,3,4,5',','));
>
> Regards
>
> Pavel Stehule
>
>
> 2011/3/5 Andre Lopes :
>> Hi,
>>
>> I need to transform an PHP array to an PlPgSQL array. The P
Hi,
I need to transform an PHP array to an PlPgSQL array. The PHP array is
like this:
[quote]
$arr = array(
0 => array(
"base64" => "ddfff",
"image_t
Hi,
Thanks for the reply.
How can I user the RETURNING without pl/sql? My PostgreSQL version is 8.3
Can you give me some example?
Best Regards,
On Mon, Feb 28, 2011 at 7:00 PM, Alban Hertroys
wrote:
> On 28 Feb 2011, at 24:37, David Johnston wrote:
>
>> Using pl/pgsql you can:
>
> You don'
that you need.
>
> David J.
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andre Lopes
> Sent: Sunday, February 27, 2011 3:34 PM
> To: postgresql Forums
> Subject: [GENERAL] Transactions
Hi,
I have a situation that I dont know how to deal.
I have 2 tables "tdir_uris_files" and "tdir_uri_files_details". Please
see the Image in attach.
The table "tdir_uris_files" have the field "id_ordinal" that is
originated by a trigger(before insert)
The table "tdir_uri_files_details" use the f
Hi,
Where can we donwload dbsteward?
Best Regards,
On Fri, Feb 11, 2011 at 5:16 AM, Bill Moran wrote:
> In response to Glenn Maynard :
>
>> On Thu, Feb 10, 2011 at 6:44 PM, Bill Moran wrote:
>>
>> > dbsteward can do downgrades ... you just feed it the old schema and
>> > the new schema in rev
Hi,
I have a problem when doing INSERT's in a table.
The table structure is:
uri (varchar 1) PK
id_language (varchar 10) PK
id_category (int4) PK
id_data (varchar 50) PK
id_ordinal (int4) PK (this field have a trigger to auto increment)
n_text (text)
When I run this function to do 90 IN
Hi,
I'm designing a database, but I'm with some doubts in the design. I
have posted a question in stackoverflow because of the use of images.
Can someone give some clues about which design should I use?
The link to the question is here:
http://stackoverflow.com/questions/4909105/database-design-
to Dmitriy Igrishin :
>
>> 2011/1/26 Andre Lopes
>>
>> > Thanks for the reply.
>> >
>> > I will mainly store files with 100kb to 250kb not bigger than this.
>> >
>> > PQescapeByteaConn is not available in a default installation of
>
,
On Tue, Jan 25, 2011 at 10:58 PM, Dmitriy Igrishin wrote:
>
>
> 2011/1/26 Andre Lopes
>>
>> Thanks for all the reply's.
>>
>> I will be using PHP for now to insert data.
>>
>> So I shouldn't use base64 to store images or any other kind of f
.
Best Regards,
On Tue, Jan 25, 2011 at 10:46 PM, Bill Moran wrote:
> In response to Peter Geoghegan :
>
>> On 25 January 2011 22:27, Andre Lopes wrote:
>> > Hi,
>> >
>> > I need to put some images on Base64 in a PostgreSQL database. Wich
>> > type
Hi,
I need to put some images on Base64 in a PostgreSQL database. Wich
type should I use and what is the difference between using bytea or
text to store Base64?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
Hi,
Thanks for the reply's. I was tempted to accept the Rodoslaw Smogura
proposal. There will be about 100 websites to capture data on daily basis.
Each website adds per day(average) 2 articles.
Thomas talked about the noSQL possibility. What do you think would be
better? I have no experience in
Hi,
I need advise about a database structure. I need to capture data from the
web about one specific subject on few specific websites and insert that data
to a database. I have done this question here before, but I think I have not
explained very well.
The problem with this task is that the infor
Hi,
I need to develop a database table that will aceept a variable array field.
My doubt is how to deal with updates on the
array field. How can I store the information of the array fields? There any
examples on the Internet on how to deal with
this subject?
What I mean with variable array is:
2010 at 1:20 PM, Jon Nelson
> wrote:
> On Wed, Dec 8, 2010 at 7:15 AM, Andre Lopes
> wrote:
> > Hi,
> >
> > I need to obtain the maximum value of a date, but that comparison will be
> > made between 3 tables... I will explain better with a query...
> >
>
Hi,
I need to obtain the maximum value of a date, but that comparison will be
made between 3 tables... I will explain better with a query...
[code]
select
a.last_refresh_date as d1, ae.last_refresh_date as d2, ha.last_refresh_date
as d3
from tbl1 a
join tbl2 ae on a.id_anuncio_externo = ae.id_anu
terno',
'38', /* id_anuncio_externo */
'2010-08-31', /* data_inicio */
'2010-12-29', /* data_fim */
'AA' /* Motivo: Aprovação Anúncio */
);
commit;
[/code]
Best Regards,
On Sun, Nov 7, 2010 at 3:41 PM, Scott Ribe wrote:
> On Nov 7, 201
The only way I can guarantee a transaction is in a Function or there are
other ways?
Best Regards,
On Sun, Nov 7, 2010 at 3:22 PM, Szymon Guz wrote:
>
>
> On 7 November 2010 16:20, Andre Lopes wrote:
>
>> Sorry for not explain well.
>>
>> I mean update more t
ible? It is the best way to do it?
Best Regards,
On Sun, Nov 7, 2010 at 3:11 PM, Scott Ribe wrote:
> On Nov 7, 2010, at 7:58 AM, Andre Lopes wrote:
>
> > need to update various tables in the same update. It is possible to do
> it?
>
> Transactions???
>
> --
> Scott Ri
Hi,
I need to update various tables in the same update. It is possible to do it?
Best Regards,
Hi,
I need to do some repetitive work in form creation to insert, update and
delete data from the database. There are some tools that handle with form
creation from a PostgreSQL database?
PS: Sorry my English.
Best Regards,
Thanks a lot! It works.
On Sat, Sep 25, 2010 at 1:23 PM, Scott Marlowe wrote:
> On Sat, Sep 25, 2010 at 6:19 AM, Andre Lopes
> wrote:
> > Hi,
> >
> > I have generate an *.sql file with the command:
> >
> > [quote]
> > pg_dump -a --inserts dat
Hi,
I have generate an *.sql file with the command:
[quote]
pg_dump -a --inserts databasename > exportfilename.sql
[/quote]
How can I use the pg_restore to import the data to the database?
I have tried:
[quote]
pg_restore -d databasename exportfilename.sql
[/quote]
But without success...
Wha
Hi,
I need to generate the dump of a PostgreSQL database only with the data with
INSERT's. It is possible to do this?
Best Regards,
Hi,
I have developed a database system where every table have a view mapping the
contents, so the users don't have direct access to the tables. For UPDATE
and DELETE I have created RULES on the views.
My question:
I will create a user to give permissions to the views. I don't know what
kind of p
Hi,
I'am trying to import an SQL file with 3gb of INSERTS. I must to change the
encode of the file to UTF8, how can I change the encode of the file without
open it? This 3gb file crashes every program...
Give me a clue.
Best Regards,
more can I do?
Best Regards,
On Sun, Jul 18, 2010 at 9:11 PM, Edoardo Panfili wrote:
> On 18/07/10 22.06, Andre Lopes wrote:
>
>> Hi,
>>
>> I have a DUMP file with INSERT's commands. I need to import this data to
>> postgresql database with the "psql"
þ-
^
[/quote]
How should I solve this problem?
Best Regards,
On Sun, Jul 18, 2010 at 9:10 PM, Szymon Guz wrote:
>
>
> 2010/7/18 Andre Lopes
>
> Hi,
>>
>> I have a DUMP file with INSERT's commands. I need to import this data to
>> postgresql database
Hi,
I have a DUMP file with INSERT's commands. I need to import this data to
postgresql database with the "psql" command.
How can I do this task?
Best Regards,
;
[/code]
If I use the clause WHERE only in "id" will not work fot both cases, or will
work?
Best Regards,
On Tue, Jul 6, 2010 at 12:46 PM, Sam Mason wrote:
> On Tue, Jul 06, 2010 at 12:28:35PM +0100, Andre Lopes wrote:
> > Ok, I have done the UPDATE RULE like this and
= NEW.remember_code,
created_on = NEW.created_on,
last_login = NEW.last_login,
active = NEW.active
where
(id = OLD.id or username = OLD.username or email = OLD.email)
[/code]
Best Regards,
On Tue, Jul 6, 2010 at 12:03 PM, Andre Lopes wrote:
> Hi Alban,
>
> But in my application I have more than o
, 2010 at 11:54 AM, Alban Hertroys <
dal...@solfertje.student.utwente.nl> wrote:
> On 6 Jul 2010, at 12:28, Andre Lopes wrote:
>
> > Now I need also to add an INSTEAD UPDATE rule and an INSTEAD DELETE rule,
> but I have some doubts about it... let me explain...
> >
Hi,
I'am using rules in views, but I'am not sure about how the rules work... let
me explain...
For example, I have this table:
[code]
CREATE TABLE "atau_utilizadores" (
"id" int4 NOT NULL,
"group_id" int4 NOT NULL,
"ip_address" char(16) NOT NULL,
"username" varchar(50) NOT NULL,
Hi,
I'am using rules in views, but I'am not sure about how the rules work... let
me explain...
For example, I have this table:
[code]
CREATE TABLE "atau_utilizadores" (
"id" int4 NOT NULL,
"group_id" int4 NOT NULL,
"ip_address" char(16) NOT NULL,
"username" varchar(50) NOT NULL,
Hi,
The function will run in the php-cli, in a CronJob, it is not for use in a
PHP webpage. I think doesn't matter the extra time that takes to run.
Best Regards,
On Sun, Jul 4, 2010 at 4:11 PM, Pavel Stehule wrote:
> 2010/7/4 Merlin Moncure :
> > On Sun, Jul 4, 2010 at 7:25 A
Hi,
I need to use an Forum Software. There is any Open Souce Forum Script using
PostgreSQL?
Best Regards,
André.
Great! That is what I need!
Thank you Pavel.
Best Regards,
On Sun, Jul 4, 2010 at 12:20 PM, Pavel Stehule wrote:
> 2010/7/4 Andre Lopes :
> > Hi,
> >
> > Thanks for your reply.
> >
> > Yes, in the Postgre command line I see the exception, the problem is that
ction not runs successful.
How can I do this?
Best Regards,
On Sun, Jul 4, 2010 at 11:05 AM, Pavel Stehule wrote:
> Hello
>
> every unsuccessful SQL command raises exception in PL/pgSQL. So if
> your function is finished without exception, then INSERT is ok.
>
> Regards
Hi,
I have a function, at the end I need to know if the INSERTS have run
successfully or not.
Here is the function:
[code]
CREATE OR REPLACE FUNCTION "apr_insert_utilizador_ap"
(IN ppgroup_id int4,
IN ppip_address char,
IN ppusername varchar,
IN pppassword varchar,
IN ppemail varchar,
IN ppactiv
Hi,
I have an account in A2Hosting.com, and I'm developing some functions that
deal with encryption.
A2Hosting.com don't have available the function "digest()"
[code]
ERROR: function digest(unknown, unknown) does not exist
LINE 1: select digest('', 'sha1')
^
HINT: No functio
Hi,
I need to create users in a database function. I'am dealing with a PHP
application, the code that generate the password is this:
[code]
public function salt()
{
return substr(md5(uniqid(rand(), true)), 0, 10);
}
public function hash_password($password, $salt=false)
Hi,
I need to return an int4 subtracting two dates, but returns me an interval.
select
end_date - now() as interger_number
from hist_anuncios
How to return an integer out of this?
Best Regards,
Hi,
How I know whether Postgres is already installed or not on a machine(on
Linux and Windows)?
I found that pg_ctl --version could be used or I also tried to check into
the registry (for windows HKLM\SOFTWARE\PostgreSQL\Installations), however
with Windows Server 2003 pg_ctl is not recognized (pr
Hi,
I need to return an Int4 when I do this king of select
[code]
select CURRENT_DATE - '2009-12-31' from tbl_sometable
[/code]
This select returns an Interval. How can I return an Integer? Like '138'
Sorry my bad english.
Best Regards,
Regards,
On Wed, May 12, 2010 at 4:45 PM, Thom Brown wrote:
> On 12 May 2010 16:30, Andre Lopes wrote:
>
>> Hi,
>>
>> I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day.
>>
>> I will need to do a full dump (schema + data), schema
Hi,
I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day.
I will need to do a full dump (schema + data), schema dump (only schema) and
data (only data)
There is something done on this subject? I'am very poor in shell script,
there are some scripts on the web ready to use?
Be
Hi,
I have a query that some values could be NULL, how can I deal with this
problem?
[code]
EXECUTE 'INSERT INTO '
|| quote_ident(pNOME_VIEW)
|| '('
|| quote_ident(pCHAVE_1)
|| ', DAT_INICIO, DAT_FIM, COMENT) values ('
|| quote_literal(pVAL_CHAVE_1)
Oh... Thanks. What a lame I'm.
Best Regards,
On Wed, May 5, 2010 at 1:25 AM, Tom Lane wrote:
> Andre Lopes writes:
> > Thanks for the reply. I have not call it STRICT...
>
> Yes you are:
>
> > RETURNS NULL ON NULL INPUT
>
> regards, tom lane
>
ou inserir uma nova linha
-- SELECT dat_inicio FROM aae_hist_anuncios WHERE id_anuncio_externo
= '5';
-- select max(dat_inicio) as max_dat_inicio from atae_hist_anuncios
END IF;
END;
$BODY$
LANGUAGE PLpgSQL
RETURNS NULL ON NULL INPUT
VOLATILE
Hi,
I have a function, that I'm debugging...
If I use NULL in any parameter the function does not RAISE any NOTICE. I
can't pass NULL values in parameters?
[code]
select apr_ins_gder_2_1
('table_fgh' /* Varchar */,
'id_fgh' /* Varchar */,
'5' /* Varchar */,
NULL /* Date */,
'2001-01-05' /* Date
Thanks. I got working.
Best Regards,
On Tue, May 4, 2010 at 10:25 PM, Adrian Klaver wrote:
> On Tuesday 04 May 2010 1:55:35 pm Andre Lopes wrote:
> > HI,
> >
> > I have a PLPgSQL function that return void but I need to exit the
> function
> > if some conditio
HI,
I have a PLPgSQL function that return void but I need to exit the function
if some condition returns true.
I have tried to do this, but I got an error:
[code]
IF pVAL_CHAVE_2 > pVAL_CAMPO1 THEN
RAISE NOTICE 'O campo data fim tem de ser maior que o campo data
inicio.';
Thanks for the reply,
It is working now.
Best Regards.
On Tue, May 4, 2010 at 7:44 AM, Maximilian Tyrtania <
maximilian.tyrta...@byte-employer.de> wrote:
> Am 03.05.2010 um 23:50 schrieb Andre Lopes:
>
> > Thanks for the reply's,
> >
> > I need to do a Dyn
Thanks for the reply's,
I need to do a Dynamic SELECT INTO. There is a way of doing it?
Best Regards,
On Mon, May 3, 2010 at 10:05 AM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to Andre Lopes :
> > Hi,
> >
> > I need to write some
Hi,
I need to write some dynamic SQL in pgsql.
I have to do something like this:
[code=SQL Server]
SET @STRINGN = @STRINGN + ' AND A.' + @CAMPOFECINI + ' IN (SELECT
MAX(B.' + @CAMPOFECINI + ')
FROM ' + @TABLA + ' B
WHERE B.ID_SOCIEDAD = A.ID_SOCIEDAD
AND B
Hi,
It is the first time that I store emails in a database to send them later...
Let me explain the problem... I'am sending text emails, and to break the
lines of the message I use "\n". The first problem was to stores the "\". To
INSERT "\n" I need to write "\\n". When I do a SELECT I see "\n" b
Hi,
I have a database were the users only can do operations using views, they
have not access to physical tables. But I have a function with a lock on a
physical table. Can I allow this users to run a function that locks a
physical table?
Best Regards,
Hi,
I need to use the BEGIN WORK; and COMMIT WORK; to lock a table when I'am
doing a SELECT and UPDATE operation.
The code is not compiling, the error is:
[error]ERROR: syntax error at or near "work" at character 1
QUERY: work
CONTEXT: SQL statement in PL/PgSQL function "apr_apanhar_ownership
1 - 100 of 202 matches
Mail list logo
