to do that, but I guess I'm moving forward, the bug
was solved and I have a google code project:
http://code.google.com/p/fuzzyquery/. Now I hope to give more features
and have a fully functional library.
2009/9/1 Hans-Juergen Schoenig -- PostgreSQL :
> Andrew Dunstan wrote:
>>
>
Hi, I have a code in which I translate some code from sqlf to sql, but
when it comes to yy_parse the server crashes, I have no idea why,
because it works fine in other situations.
This is the code (the problem is in parse_sqlf, when I call sqlf_yyparse):
#include "postgres.h"
#include "gram.h"
#
2009/8/28 Andrew Dunstan :
> You function doesn't look too immutable. Is it really?
Hi, I fixed that, but the server continues to crash, where can I see a
full example of something using the SRF functions to parse a query?
All examples I see set the columns, but I parse a query that I don't
have a
Hi, I need to return a set of records from a query, first I translate
from sqlf to sql and later I wanna return the query, but the server
crash (I guess it crashes around the yyparse call).
This is the sql:
CREATE OR REPLACE FUNCTION sqlf (text) RETURNS SETOF record
AS 'MODULE_PATHNAME', 'sqlf'
L
Hi, I wanna return a group of rows, like when you do "SELECT columns FROM
table", but I'm getting some troubles, I don't know if I have to use
HeapTuple or Datum. I'm using bison to parse sqlf to sql this way:
-- some code
%%
query: /* empty string */
| query command
;
command: '\n'
| Crea
>
>
> What use is there for fuzzy predicates? I think it would mainly be to
> stop more students from coming up with new implementations of the same
> thing over and over.
>
Well, I'm sorry if anyone of us who is involved on these projects have
already explain the true usefulness of sqlf and fuzz
e any requirement I have to follow?
2009/8/6 Tom Lane
> Werner Echezuria writes:
> > I'm trying to develop a contrib module in order to parse sqlf queries,
> I'm
> > using lemon as a LALR parser generator (because I think it's easier than
> > bison) and re2c (beca
Hi,
I'm trying to develop a contrib module in order to parse sqlf queries, I'm
using lemon as a LALR parser generator (because I think it's easier than
bison) and re2c (because I think it's easier than flex) but when I try to
split the string into words postgres add some weird characters (this wor
Hi,
what is a canonical pathkey?
Thanks
2009/4/28 Tom Lane
> Well, you've omitted showing us the code where the problem is likely to
> be, but I am kinda thinking that you've shot yourself in the foot by
> trying to represent your special ordering clause as a simple constant.
> The planner is quite smart enough to throw away "order by
use?
2009/4/28 Martijn van Oosterhout
> On Sun, Apr 26, 2009 at 08:33:42PM -0430, Werner Echezuria wrote:
> > Well, I do a query like this: "SELECT * FROM historial WHERE
> > id_grupo=grupo_hist ORDER BY grmemb LIMIT 10;", then in
> transformSortClause
> > I know i
s(root,
result_plan,
sort_pathkeys,
limit_tuples);
current_pathkeys = sort_pathkeys;
}
}
2009/4/26 Martijn
Hi, I've been trying to sort a column that performs some calculations, but
postgres says this: ERROR: invalid attnum: -12851. I was searching on the
source code, and I guess the error araises around this macro:
/*
* Copy the given tuple into memory we control, and decrease availMem.
* Th
clude
somewhere in the tuplesort the column?
2009/4/2 Werner Echezuria
>
> Hi, the problem goes on. I think the problem is in the planner.c on
> grouping_planner function, because when I do a regular sort it gets to it:
>
> /*
> * If we were not able to make the plan come
ike this "invalid attnum", so when I go to heaptuple and
force to get to ObjectIdGetDatum in heap_getsysattr, the server hang out.
What can I do? How can I assign a valid attrnum?
2009/4/1 Hitoshi Harada
> 2009/4/1 Werner Echezuria :
> > As you can see if someone do this: SEL
Hi,
I'm in a project that probably some of you have heart about, it is called
PostgreSQLf and I get some help before from this list. The developer team is
been doing some progress about. Now one of us has created an extra column
that is called membership degree, this performs some calculations ove
Hello, (First of all, sorry for my english),
I'm in a project that involves including sqlf sentences to make postgres
understand the fuzzy querys, i mean, make people to create fuzzy
predicates, these are words like fat, tall, young, old, in an sql sentence.
I guess the first step is complete. T
Hello,
I've suscribed to this mailing list for help, I will work on a
Specialization Degree Thesis, this will be a PostgreSQL implementation of
fsql, or fuzzy querys.
http://www.lcc.uma.es/~ppgg/FSQL.html, this is a link to a webpage who made
this in Oracle, but it's not inside of course, becaus
18 matches
Mail list logo
