Re: [HACKERS] Bison crashes postgresql

2009-09-01 Thread Werner Echezuria
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 postg...@cybertec.at: Andrew Dunstan wrote: Werner

[HACKERS] Bison crashes postgresql

2009-08-31 Thread Werner Echezuria
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

Re: [HACKERS] return a set of records

2009-08-28 Thread Werner Echezuria
2009/8/28 Andrew Dunstan and...@dunslane.net: 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

[HACKERS] return a set of records

2009-08-27 Thread Werner Echezuria
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'

[HACKERS] return HeapTuple

2009-08-25 Thread Werner Echezuria
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' |

Re: [HACKERS] problem with splitting a string

2009-08-06 Thread Werner Echezuria
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 fuzzy

[HACKERS] problem with splitting a string

2009-08-05 Thread Werner Echezuria
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

Re: [HACKERS] problem with splitting a string

2009-08-05 Thread Werner Echezuria
...@sss.pgh.pa.us Werner Echezuria werc...@gmail.com 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 (because I think it's easier than flex) but when I try to split the string

[HACKERS] canonical pathkey

2009-05-17 Thread Werner Echezuria
Hi, what is a canonical pathkey? Thanks

Re: [HACKERS] To know what a macro does

2009-04-27 Thread Werner Echezuria
Martijn van Oosterhout klep...@svana.org 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 it this way: Ok, this is way over my head

Re: [HACKERS] To know what a macro does

2009-04-27 Thread Werner Echezuria
2009/4/28 Tom Lane t...@sss.pgh.pa.us 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

[HACKERS] To know what a macro does

2009-04-26 Thread Werner Echezuria
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. *

Re: [HACKERS] To know what a macro does

2009-04-26 Thread Werner Echezuria
, sort_pathkeys, limit_tuples); current_pathkeys = sort_pathkeys; } } 2009/4/26 Martijn van Oosterhout klep...@svana.org On Sun, Apr 26, 2009 at 04:20:41PM -0430, Werner Echezuria wrote

Re: [HACKERS] Sort a column that does not exist

2009-04-07 Thread Werner Echezuria
somewhere in the tuplesort the column? 2009/4/2 Werner Echezuria werc...@gmail.com 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 out in the right

Re: [HACKERS] Sort a column that does not exist

2009-04-02 Thread Werner Echezuria
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 umi.tan...@gmail.com 2009/4/1 Werner Echezuria werc...@gmail.com: As you can see if someone do

[HACKERS] Sort a column that does not exist

2009-03-31 Thread Werner Echezuria
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

[HACKERS] SQLF Optimization question

2007-05-31 Thread Werner Echezuria
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.

[HACKERS] Help with Degree Work

2007-01-24 Thread Werner Echezuria
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,