Adam Mackler-5 wrote
(Cross-posted to StackOverflow:
http://stackoverflow.com/questions/25041100/postgresql-user-defined-operator-function-what-parameter-type-to-use-for-uncast
)
I'm defining my own domain and a equality operator.
Next I create an equality operator to do case-insensitive
I have played around with it a bit more, it seems adding the pre-start
section works:
pre-start script
if [ -d /var/run/postgresql ]; then
chmod 2775 /var/run/postgresql
else
install -d -m 2775 -o postgres -g postgres /var/run/postgresql
fi
end script
Thanks Adrian!
On Wed, Jul 30, 2014 at 10:59:28PM -0700, David G Johnston wrote:
ISTM that if this was supported you would be doing it correctly.
Thank you for the quick response. I'm not understanding you. Could you
elaborate?
The main problem is you are abusing DOMAIN - which is strictly the
base
On Thu, Jul 31, 2014 at 12:19 AM, Adam Mackler-5 [via PostgreSQL]
ml-node+s1045698n5813399...@n5.nabble.com wrote:
On Wed, Jul 30, 2014 at 10:59:28PM -0700, David G Johnston wrote:
ISTM that if this was supported you would be doing it correctly.
Thank you for the quick response. I'm not
Thank you for your response guys.
On Wed, Jul 30, 2014 at 9:25 PM, Chris Curvey ch...@chriscurvey.com wrote:
On Wed, Jul 30, 2014 at 8:41 PM, Emir Ibrahimbegovic
emir.ibrahimbego...@gmail.com wrote:
Hello all,
I've got two queries which should produce the same results but they don't
On 07/30/2014 10:25 PM, Tonny wrote:
Hi everyone I read that 2ndQuadrant released bidirectional replication
for postgres,
know whether this package will enter apt.postgresql.org or if there will
be any repository
for Debian GNU / Linux?
Information is here:
On 07/31/2014 05:44 AM, Emir Ibrahimbegovic wrote:
Thank you for your response guys.
So, did you find the cause?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Yes there was some users subscribed at different date than payment was
made. So I used this to get the results on the daily basis :
SELECT date_trunc('day', payments.created_at) day,
SUM(payments.amount) AS sum_id
FROM payments
INNER JOIN users ON users.id = payments.user_id
WHERE
Chris Curvey ch...@chriscurvey.com wrote:
Emir Ibrahimbegovic emir.ibrahimbego...@gmail.com wrote:
So looking for same date using different date range I get
different results, how is this even possible? Can I look at
something else? I'm really stuck here
Remove the sum (just select
On Wed, Jul 30, 2014 at 5:43 AM, Andrus kobrule...@hot.ee wrote:
How to create string concatenation operator which preserves trailing spaces
on CHAR(n) type columns ?
hm, why do that at all? how about avoid the char() type and create
views over tables using rpad when you want space padding:
On Tue, Jul 22, 2014 at 4:36 AM, Rebecca Clarke r.clark...@gmail.com wrote:
Hi all,
Presently I'm executing a function that runs many queries within it.
select * from _myfunction();
Is there a way to see what query it is up to within the function?
When I do a select of pg_stat_activity it
Hi,
hm, why do that at all? how about avoid the char() type and create
views over tables using rpad when you want space padding:
create view v_foo as
select *, rpad(f, 50, ' ') as f_padded;
I'm creating a converter which converts Visual FoxPro expressions to
Postgres at runtime.
FoxPro
Adam Mackler pgsql-gene...@mackler.org wrote:
CREATE domain my_domain as char(3) check(VALUE similar to '[A-C]{3}');
CREATE TABLE my_table (val my_domain);
INSERT INTO my_table VALUES ('ABC');
sandbox= SELECT * FROM my_table WHERE val='abc';
val
-
(0 rows)
David G Johnston david.g.johns...@gmail.com writes:
On Thu, Jul 31, 2014 at 12:19 AM, Adam Mackler-5 [via PostgreSQL]
ml-node+s1045698n5813399...@n5.nabble.com wrote:
Can you explain what the abuse is? Also why the = operator does not
work even without the domain?
When you write,
On Fri, Jun 6, 2014 at 04:29:59PM +0530, Atri Sharma wrote:
On Fri, Jun 6, 2014 at 4:22 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote:
Hello, I am Ravikiran, pursuing my third year BITS Pilani, India, I am
doing my thesis in postgress technology,
The project is about
I want to call a function using a column of a table as the parameter and
return the parameter and function results together.
The problem is, when the function returns an empty row my select statement
that uses the function returns an empty row as well.
Hello,
not sure if it makes sense in
I want to implement something akin to OO inheritance among DB tables. The
idea is to define some superclass table, e.g.:
CREATE TABLE super (
super_id INT PRIMARY KEY,
...
-- other columns
);
CREATE TABLE sub_1 (
super_id INT PRIMARY KEY,
On Thu, Jul 31, 2014 at 9:38 PM, Kynn Jones kyn...@gmail.com wrote:
Does PostgreSQL have a good way to enforce the uniqueness of super_id values
across multiple tables?
Well that's easy: no.
Regards,
Marti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 07/31/2014 12:38 PM, Kynn Jones wrote:
I want to implement something akin to OO inheritance among DB tables.
The idea is to define some superclass table, e.g.:
CREATE TABLE super (
super_id INT PRIMARY KEY,
...
-- other columns
);
CREATE TABLE sub_1 (
On 07/31/2014 01:16 PM, Marti Raudsepp wrote:
On Thu, Jul 31, 2014 at 9:38 PM, Kynn Jones kyn...@gmail.com wrote:
Does PostgreSQL have a good way to enforce the uniqueness of super_id values
across multiple tables?
Well that's easy: no.
Regards,
Marti
That might be a little hasty. There
Hi,
I would like to create a GIN index on a set of JSON documents. Right now
I'm storing the data in a JSONB column. The current index looks like this:
CREATE INDEX document_payload_idx
ON document
USING gin
(payload jsonb_path_ops);
The index is pretty small, but the actual data takes up
Kynn Jones kyn...@gmail.com wrote:
I want to implement something akin to OO inheritance among DB
tables. The idea is to define some superclass table, e.g.:
CREATE TABLE super (
super_id INT PRIMARY KEY,
...
-- other columns
);
CREATE TABLE sub_1 (
Hi,
I'm running an experiment on 9.4 beta 2.
I put 275,000 identical JSON files into a table using JSONB (one per row).
Each raw text file is 251K in size, so the total uncompressed is 69GB. The
column storage is set to EXTENDED. There are other toastable columns in
the table, but none have
On Fri, Aug 1, 2014 at 4:47 AM, Larry White ljw1...@gmail.com wrote:
Is there a way to get Postgres to index the table as if the JSON were there,
but not actually put the data in the table?
I could either store the docs
elsewhere and keep a reference, or compress them and put them in the table
On 07/31/2014 01:44 PM, Larry White wrote:
Hi,
I'm running an experiment on 9.4 beta 2.
I put 275,000 identical JSON files into a table using JSONB (one per
row). Each raw text file is 251K in size, so the total uncompressed is
69GB. The column storage is set to EXTENDED. There are other
Yes. It was EXTENDED.
As a further test, I dropped the table and rebuilt it, explicitly changing
the EXTENDED designation to EXTERNAL and got exactly the same size TOAST
table. So there was no compression at all with storage set to EXTENDED.
On Thu, Jul 31, 2014 at 11:51 PM, Adrian Klaver
On Fri, Aug 1, 2014 at 10:48 AM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Fri, Aug 1, 2014 at 4:47 AM, Larry White ljw1...@gmail.com wrote:
Is there a way to get Postgres to index the table as if the JSON were there,
but not actually put the data in the table?
I could either store
27 matches
Mail list logo