On Thu, Mar 28, 2013 at 08:50:50PM +, Severn, Chris wrote:
What I want to do is return items that have 'Robocop' or 'Robocop and
DVD' or 'Robocop and Collection' or 'Robocop and DVD and collection'
Based on the criteria above, I would say that:
SELECT m.* FROM movies m WHERE
Because the query is what the user is typing in. I don't know what words the
user is going to search for. if they simply search for 'Robocop' that would
work. But how do I handle the search if they type in more than one word and
still return half way accurate results?
I suppose after talking
Some people wrote:
... Hmm... This should optionally apply to time.
... for anything that really matters, I'll work with UTC.
Is there a Godwin's law
http://en.wikipedia.org/wiki/Godwin's_law equivalent for when
our conversations end up with timezones getting mentioned? :)
Regards
Gavan
On Wed, Mar 27, 2013 at 9:03 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Gavin Flower gavinflo...@archidevsys.co.nz writes:
The rule appears to be,
where N_x N_y are the number of entries returned for x y:
N_result = is the smallest positive integer that has N_x N_y as factors.
Right: if there
Some thoughts.
The current MONEY type might be considered akin to ASCII.
Perfect for a base US centric accounting system where there are
cents and dollars and no need to carry smaller fractions. As
discussed, there are some details that could be refined.
When it comes to this type being
Gavan Schneider pg-...@snkmail.com writes:
Therefore the discussion is really about the desired role for
the MONEY type. Should it be refined in its current dallar and
cents mode? or, be promoted to a more universal role (akin to a
shift from ASCII to UTF)?
Well, this has been discussed
Yesterday morning, one of my streaming replication slaves running 9.2.3
crashed with the following in the log file:
2013-03-28 12:49:30 GMT WARNING: page 1441792 of relation base/63229/63370
does not exist
2013-03-28 12:49:30 GMT CONTEXT: xlog redo delete: index
1663/63229/109956; iblk 303,
Looks like you've got some form of coruption:
page 1441792 of relation base/63229/63370 does not exist
The question is whether it was corrupted on the master and then
replicated to the slave, or if it was corrupted on the slave. I'd
guess that the pg_dump tried to read from that page and
On Fri, 29 Mar 2013 11:46:40 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Well, this has been discussed before, and the majority view every
time has been that MONEY is a legacy thing that most people would
rather rip out than sink a large amount of additional effort into.
It has some use-cases but
On Fri, Mar 29, 2013 at 10:23 AM, Lonni J Friedman netll...@gmail.comwrote:
Looks like you've got some form of coruption:
page 1441792 of relation base/63229/63370 does not exist
Thanks for the insight. I thought that might be it, but never having seen
this before I'm glad to have some
Quentin Hartman qhart...@direwolfdigital.com writes:
Yesterday morning, one of my streaming replication slaves running 9.2.3
crashed with the following in the log file:
What process did you use for setting up the slave?
There's a fix awaiting release in 9.2.4 that might explain data
corruption
On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Quentin Hartman qhart...@direwolfdigital.com writes:
Yesterday morning, one of my streaming replication slaves running 9.2.3
crashed with the following in the log file:
What process did you use for setting up the slave?
Quentin Hartman qhart...@direwolfdigital.com writes:
On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What process did you use for setting up the slave?
I used an rsync from the master while both were stopped.
If the master was shut down cleanly (not -m immediate) then the
On Fri, Mar 29, 2013 at 10:50 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Quentin Hartman qhart...@direwolfdigital.com writes:
On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What process did you use for setting up the slave?
I used an rsync from the master while both were
Hello colleagues !
I have to write pl/pgsql function that has to be triggered not before/after
insert, but in definite time. Does postgresql allows to do this ?
Thanks a lot.
--
Best regards,
Sincerely yours,
Yuriy Rusinov.
On 3/29/2013 10:54 AM, Yuriy Rusinov wrote:
I have to write pl/pgsql function that has to be triggered not
before/after insert, but in definite time. Does postgresql allows to
do this ?
there is no 'cron' built into postgresql. you could write your
function, then have an external cron
On 3/29/2013 11:13 AM, John R Pierce wrote:
there is no 'cron' built into postgresql.
actually, there is pgAgent, which is associated with the pgAdmin
package, this implements a cron-like facility to postgres.
http://www.pgadmin.org/docs/1.16/pgagent.html
--
john r pierce
On 28 March 2013 13:52, Shaun Thomas stho...@optionshouse.com wrote:
On 03/28/2013 07:43 AM, Gavan Schneider wrote:
Personally I have ignored the money type in favour of numeric. Money
seemed to do too much behind the scenes for my taste, but, that's me
being lazy as well, I haven't spend
On Thu, 2013-03-28 at 23:43 +1100, Gavan Schneider wrote:
If the money type is meant to be serious then these
conventions need to be followed/settable on a column by column
basis.
I don't like the idea of tying the semantics to a column. That leaves
out values that aren't stored in a column,
On 3/27/13, Steve Crawford scrawf...@pinpointresearch.com wrote:
Somewhat more worrisome is the fact that it automatically rounds input
(away from zero) to fit.
select '123.456789'::money;
money
-
$123.46
So does casting to an integer:
select 1.25::integer
;
int4
1
Thanks Janes...
I am not a C developer - was not aware about select()... I was read it as
some kind of sleep...
Than Clemens explained to me what select() does...
However - to me it is just implementation detail... Which is possible in
one language, but not in another...
But technically, is
On Fri, 29 Mar 2013 12:02:49 -0700
Jeff Davis pg...@j-davis.com wrote:
On Thu, 2013-03-28 at 23:43 +1100, Gavan Schneider wrote:
If the money type is meant to be serious then these
conventions need to be followed/settable on a column by column
basis.
I don't like the idea of tying the
On 29/3/13 at 3:32 AM, D'Arcy J.M. Cain wrote:
On Fri, 29 Mar 2013 11:46:40 -0400 Tom Lane wrote:
Well, this has been discussed before, and the majority view every
time has been that MONEY is a legacy thing that most people would
rather rip out than sink a large amount of additional effort
I've been looking at unique indices in a PostgreSQL 8.3.x cluster. Some
unique indices clearly have a corresponding row in pg_constraint, while
other unique indices appear to have no corresponding row in
pg_constraint at all.
Why is this? What determines if a unique index will also have a
Misa Simic wrote:
I am not a C developer - was not aware about select()... I was read it as
some kind of sleep...
php provides socket_select() as an equivalent to C's select().
See http://php.net/manual/en/function.socket-select.php
But it takes socket resources as arguments and the
Ed L. pg...@bluepolka.net writes:
Why is this? What determines if a unique index will also have a row in
pg_constraint?
If you made it with constraint syntax, it'll have such a row.
If you made it with CREATE INDEX, not.
regards, tom lane
--
Sent via pgsql-general
On Fri, 2013-03-29 at 16:30 -0400, D'Arcy J.M. Cain wrote:
How would this be an issue? If you are assigning a literal to a column
then that's no issue. Otherwise, a literal is simply a value that can
be cast depending on the situation. The money type is no different in
that regard.
As a
On 30/3/13 at 9:30 AM, I wrote:
I have sketched something of a notation for MONEY columns along these lines:
amt_received MONEY (CURRENCY-- e.g., 'USD' 'AUD' 'YEN' ...
[,SCALE -- default as per currency, e.g. USD 2 decimals
-- but could be used to see money in bigger units
-- such
On Sat, Mar 30, 2013 at 3:13 AM, John R Pierce pie...@hogranch.com wrote:
On 3/29/2013 10:54 AM, Yuriy Rusinov wrote:
I have to write pl/pgsql function that has to be triggered not
before/after insert, but in definite time. Does postgresql allows to do
this ?
there is no 'cron' built
List,
I have a data modeling problem. That much, I know. The question is how do I
model this? (Below.)
I'm making a database which will store pseudo-genetic data. It's a basic
many-to-many setup::
create table person(
name varchar(32) primary key
);
create table gene(
30 matches
Mail list logo
