Hi,
#define DatumGetNDBOX(x)((NDBOX*)DatumGetPointer(x))
#define PG_GETARG_NDBOX(x)DatumGetNDBOX(
PG_DETOAST_DATUM(PG_GETARG_DATUM(x)) )
Now i have to define
#define NDBOXGetDatum(x) ()PointerGetDatum(x)
Is there any need to replace this ?? with some toastable thing or is it
suff
On Sun, 15 May 2011 20:05:04 +0200
Cédric Villemain wrote:
>2011/5/15 Rob Sargent :
>>
>>
>> Tarlika Elisabeth Schmitz wrote:
>>>
>>> I have a database that will be populated solely by CSV import.
>>> There are several CSV file formats, all denormalized.[...]
>
>pgloader may be useful:
>http://pg
Hi,
I have defined some function and also used NDBOX structure that having
variable length.
typedef struct NDBOX
{
int32vl_len_;/* varlena length */
unsigned int dim;
doublex[1];
} NDBOX;
When i called my function, it gives NDBOX to be null
On debugging, i foun
Dear All,
I am new to Postgresql. I have a field with lots of dublicate words and i want
to remove any dublicate word from that field.
For example, if i have a field with a string " one, one, two, two, three", how
would i get " one, two, three" only ?
Any help is much apprecieated !
Sukuchha
On 16/05/2011 13:34, Sukuchha Shrestha wrote:
Dear All,
I am new to Postgresql. I have a field with lots of dublicate words and
i want to remove any dublicate word from that field.
For example, if i have a field with a string " one, one, two, two,
three", how would i get " one, two, three" only
I would use a plpython or plperl function
In python you can split the word into a list and then get unique items
and put it back in a string, for example.
Sim
On 05/16/2011 03:34 PM, Sukuchha Shrestha wrote:
Dear All,
I am new to Postgresql. I have a field with lots of dublicate words
Dear sir,
We are trying to install the Postgre-Sql 9.0. In some Win-Xp systems, the
postgre sql is installed & working properly. But in some Win-XP systems,
it was installed but the Service could not be started. In Win-Vista system,
even the Service is not installed. When we analysis the probl
Hello
2011/5/16 Sukuchha Shrestha :
> Dear All,
> I am new to Postgresql. I have a field with lots of dublicate words and i
> want to remove any dublicate word from that field.
> For example, if i have a field with a string " one, one, two, two, three",
> how would i get " one, two, three" only ?
Hi Pavel,
Thanks for your code. I am using postgresql 8.3 so dont have unnest function in
my postgresql. But i found equivalend code for unnest in internet. Afterwards i
tried your code, and it worked !!
Thanks for the help ! you saved me from being a dead man.
Sukuchha
__
2011/5/16 Sukuchha Shrestha :
> Hi Pavel,
> Thanks for your code. I am using postgresql 8.3 so dont have unnest function
> in my postgresql. But i found equivalend code for unnest in internet.
> Afterwards i tried your code, and it worked !!
> Thanks for the help ! you saved me from being a dead m
Start with January 1st, 2011
Generate Series 0 ~ 200
Add (Series# * 7) Days to January 1st := CheckDate
Filter where day(CheckDate) <= 7
Filter where CheckDate <= December 31st 2013
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf O
Hi John,
Thanks for the quick response. I'll elaborate on the *actual* problem.
Basically, I want to call:
select * from partiesWithin("DAYTONA", "FL", 5);
The partiesWithin() function finds all zip codes (and zip_code centroids),
then searches a 5 (or n) mile radius around those centroids for pa
Please read section “39.6.1. Returning From a Function” in the pl/pgsql section
of the documentation (actually, you should read the entire section on pl/pgsql
programming).
“RETURN QUERY appends the results of executing a query to the function's result
set.” [when used with RETURNING SETOF *
On Mon, May 16, 2011 at 7:04 AM, Kalai R wrote:
> Dear sir,
>
> We are trying to install the Postgre-Sql 9.0. In some Win-Xp systems, the
> postgre sql is installed & working properly. But in some Win-XP systems,
> it was installed but the Service could not be started. In Win-Vista system,
> ev
Wow, you guys are some fast-acting dudes (and yes, I *am* an adult, but a
kid at heart).
David, yup, that's exactly the part of the documentation that I read, and
that is confusing me, because when I try it at home, it's not working. In
fact, the exact example that I'm showing in the first email u
I created a modifier for auto incrementing my primary key as follows:
records=# \d users
Table "public.users"
Column | Type | Modifiers
+---+
id
2011/5/11 Alex - :
> Hi,
> is there an easy way to return the date of every first Saturday of a month
> in a data range i.e. 2011-2013
> Any help would be appreciated
> Thanks
> Alex
Try:
SELECT s.a::date+(6-(extract(dow from s.a)::int%7)) FROM
generate_series(to_date('2011',''),to_date('2012
Hello all,
First time poster here - probably a good sign since I've been running
postgresql with zero issues for the last several years! At any rate, I've
recently run into a strange issue. Client-based EOFs are nothing new to our
application; people can sometimes close a connection for a number
Hello
2011/5/16 Bernardo Telles :
> Wow, you guys are some fast-acting dudes (and yes, I am an adult, but a kid
> at heart).
>
> David, yup, that's exactly the part of the documentation that I read, and
> that is confusing me, because when I try it at home, it's not working. In
> fact, the exact e
Christopher Opena writes:
> Hello all,
> First time poster here - probably a good sign since I've been running
> postgresql with zero issues for the last several years! At any rate, I've
> recently run into a strange issue. Client-based EOFs are nothing new to our
> application; people can somet
Carlos Mennens wrote:
> I created a modifier for auto incrementing my primary key as follows:
>
> records=# \d users
> Table "public.users"
> Column | Type | Modifiers
> +---+-
Thanks for the reply, Tom. I admit we were a bit rushed during the
troubleshooting process; now that we know precisely how to identify these
procs and deal with them, I imagine we'll grab more info next time before
killing them, including a netstat view and a stack trace per your
recommendation.
Hi:
Is there a way to suppress the "INSERT x x" and "DELETE y" (etc...) messages
in psql?
Thanks in advance
On May 17, 2011, at 3:17 AM, Gauthier, Dave wrote:
> Is there a way to suppress the "INSERT x x" and "DELETE y" (etc...) messages
> in psql?
psql -q
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Wordpress:http://vibho
I've a table like:
CREATE TABLE ordiniitem
(
idordine numeric(18,0) NOT NULL,
grupposped smallint,
idart numeric(18,0) NOT NULL,
qevasa integer,
qfuoricat integer,
qinris integer,
qnonpub integer,
qann integer,
qord integer,
qpren integer,
qrichpag integer,
qinriass integer
On Tue, 10 May 2011 15:59:07 +0200
Ivan Sergio Borgonovo wrote:
Sorry for the noise. The csv was automatically generated. The code
was right but during generation there was some problem with the box
generating it (php segfaulting) and there were some unclosed quotes
in a much earlier line.
Postg
When asking for help on non-trivial SELECT queries it really helps to tell
us the version of PG you are using so that responders know what
functionality you can and cannot use. In this case specifically, whether
WINDOW (and maybe WITH) clauses available?
David J.
> -Original Message-
> F
On Mon, 16 May 2011 20:05:45 -0400
"David Johnston" wrote:
> When asking for help on non-trivial SELECT queries it really helps
> to tell us the version of PG you are using so that responders know
> what functionality you can and cannot use. In this case
> specifically, whether WINDOW (and maybe
Hi Pavel, I'm running 8.4
On Mon, May 16, 2011 at 3:58 PM, Pavel Stehule wrote:
> Hello
>
> 2011/5/16 Bernardo Telles :
> > Wow, you guys are some fast-acting dudes (and yes, I am an adult, but a
> kid
> > at heart).
> >
> > David, yup, that's exactly the part of the documentation that I read, an
Dear all,
Today I grant a user all privileges to all tables in a database by
grant all privileges on svo_data_social to neha ;
grant all privileges on svo_phrases to neha ;
.. . .
.
...
Now i find it very uncomfort to grant privileges one by one table.
Is there a
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/
Postgres Production Servers.
We have databases from 20 to 230 GB and it's not the OLTP just a simple
OLAP where data is fetched and stored in some meaningful for
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
> Dear all,
>
> I need to research on Memcache in the next few days.
>
> What I want to know is it worth to have memcahed enable in our Mysql/
> Postgres Production Servers.
> We have databases from 20 to 230 GB and it's not the OLTP just a si
Rick Genter wrote:
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/ Postgres
Production Servers.
We have databases from 20 to 230 GB and it's not the OLTP
Hi,
2011/05/17 14:31, Adarsh Sharma wrote:
Rick Genter wrote:
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/ Postgres
Production Servers.
We have databa
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote:
> Rick Genter wrote:
>>
>> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
>>
>>
>>> Dear all,
>>>
>>> I need to research on Memcache in the next few days.
>>>
>>> What I want to know is it worth to have memcahed enable in our Mysql/
>
35 matches
Mail list logo