<!--

$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.67 2003/04/10 01:22:45 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.68 2003/05/29 20:40:36 tgl Exp $

-->

<sect1 id="xfunc">

<screen>

SELECT new_emp().name;

ERROR:parser: parse error at or near "."

ERROR:syntax error at or near "."

</screen>

</para>

$(srcdir)/gram.c:$(srcdir)/parse.h ;

$(srcdir)/parse.h: gram.y

$(YACC) -d $(YFLAGS) $<

sed -e 's/"syntax error/"parse error/' <y.tab.c > $(srcdir)/gram.c

mv -fy.tab.c $(srcdir)/gram.c

mv -f y.tab.h $(srcdir)/parse.h

rm -f y.tab.c

else

@$(missing) bison $< $@

elog(ERROR,"sub-SELECT in FROM must have an alias"

"\n\tFor example, FROM (SELECT ...) [AS] foo");

cursorpos =pg_mbstrlen_with_len(scanbuf, loc - scanbuf) +1;

if (*loc == YY_END_OF_BUFFER_CHAR)

{

ereport(ERROR,

(errmsg("parser:%s at end of input", message),

(errmsg("%s at end of input", message),

errposition(cursorpos)));

}

{

ereport(ERROR,

(errmsg("parser:%s at or near\"%s\"", message, loc),

(errmsg("%s at or near\"%s\"", message, loc),

errposition(cursorpos)));

}

}

-- missing relation name

select;

ERROR:parser: parse error at or near ";" at character 7

ERROR:syntax error at or near ";" at character 7

-- no such relation

select * from nonesuch;

ERROR: Relation "nonesuch" does not exist

-- missing target list

select from pg_database;

ERROR:parser: parse error at or near "from" at character 8

ERROR:syntax error at or near "from" at character 8

-- bad name in target list

select nonesuch from pg_database;

ERROR: Attribute "nonesuch" not found

ERROR: Attribute "nonesuch" not found

-- bad select distinct on syntax, distinct attribute missing

select distinct on (foobar) from pg_database;

ERROR:parser: parse error at or near "from" at character 29

ERROR:syntax error at or near "from" at character 29

-- bad select distinct on syntax, distinct attribute not in target list

select distinct on (foobar) * from pg_database;

ERROR: Attribute "foobar" not found

-- missing relation name (this had better not wildcard!)

delete from;

ERROR:parser: parse error at or near ";" at character 12

ERROR:syntax error at or near ";" at character 12

-- no such relation

delete from nonesuch;

ERROR: Relation "nonesuch" does not exist

-- missing relation name (this had better not wildcard!)

drop table;

ERROR:parser: parse error at or near ";" at character 11

ERROR:syntax error at or near ";" at character 11

-- no such relation

drop table nonesuch;

ERROR: table "nonesuch" does not exist

-- relation renaming

-- missing relation name

alter table rename;

ERROR:parser: parse error at or near ";" at character 19

ERROR:syntax error at or near ";" at character 19

-- no such relation

alter table nonesuch rename to newnonesuch;

ERROR: Relation "nonesuch" does not exist

-- missing index name

drop index;

ERROR:parser: parse error at or near ";" at character 11

ERROR:syntax error at or near ";" at character 11

-- bad index name

drop index 314159;

ERROR:parser: parse error at or near "314159" at character 12

ERROR:syntax error at or near "314159" at character 12

-- no such index

drop index nonesuch;

ERROR: index "nonesuch" does not exist

-- missing aggregate name

drop aggregate;

ERROR:parser: parse error at or near ";" at character 15

ERROR:syntax error at or near ";" at character 15

-- missing aggregate type

drop aggregate newcnt1;

ERROR:parser: parse error at or near ";" at character 23

ERROR:syntax error at or near ";" at character 23

-- bad aggregate name

drop aggregate 314159 (int);

ERROR:parser: parse error at or near "314159" at character 16

ERROR:syntax error at or near "314159" at character 16

-- bad aggregate type

drop aggregate newcnt (nonesuch);

ERROR: Type "nonesuch" does not exist

-- missing function name

drop function ();

ERROR:parser: parse error at or near "(" at character 15

ERROR:syntax error at or near "(" at character 15

-- bad function name

drop function 314159();

ERROR:parser: parse error at or near "314159" at character 15

ERROR:syntax error at or near "314159" at character 15

-- no such function

drop function nonesuch();

ERROR: RemoveFunction: function nonesuch() does not exist

-- missing type name

drop type;

ERROR:parser: parse error at or near ";" at character 10

ERROR:syntax error at or near ";" at character 10

-- bad type name

drop type 314159;

ERROR:parser: parse error at or near "314159" at character 11

ERROR:syntax error at or near "314159" at character 11

-- no such type

drop type nonesuch;

ERROR: Type "nonesuch" does not exist

-- missing everything

drop operator;

ERROR:parser: parse error at or near ";" at character 14

ERROR:syntax error at or near ";" at character 14

-- bad operator name

drop operator equals;

ERROR:parser: parse error at or near ";" at character 21

ERROR:syntax error at or near ";" at character 21

-- missing type list

drop operator ===;

ERROR:parser: parse error at or near ";" at character 18

ERROR:syntax error at or near ";" at character 18

-- missing parentheses

drop operator int4, int4;

ERROR:parser: parse error at or near "," at character 19

ERROR:syntax error at or near "," at character 19

-- missing operator name

drop operator (int4, int4);

ERROR:parser: parse error at or near "(" at character 15

ERROR:syntax error at or near "(" at character 15

-- missing type list contents

drop operator === ();

ERROR:parser: parse error at or near ")" at character 20

ERROR:syntax error at or near ")" at character 20

-- no such operator

drop operator === (int4);

ERROR: parser: argument type missing (use NONE for unary operators)

ERROR: parser: argument type missing (use NONE for unary operators)

-- no such type1

drop operator = ( , int4);

ERROR:parser: parse error at or near "," at character 19

ERROR:syntax error at or near "," at character 19

-- no such type1

drop operator = (nonesuch, int4);

ERROR: Type "nonesuch" does not exist

ERROR: Type "nonesuch" does not exist

-- no such type2

drop operator = (int4, );

ERROR:parser: parse error at or near ")" at character 24

ERROR:syntax error at or near ")" at character 24

--

-- DROP RULE

-- missing rule name

drop rule;

ERROR:parser: parse error at or near ";" at character 10

ERROR:syntax error at or near ";" at character 10

-- bad rule name

drop rule 314159;

ERROR:parser: parse error at or near "314159" at character 11

ERROR:syntax error at or near "314159" at character 11

-- no such rule

drop rule nonesuch on noplace;

ERROR: Relation "noplace" does not exist

-- bad keyword

drop tuple rule nonesuch;

ERROR:parser: parse error at or near "tuple" at character 6

ERROR:syntax error at or near "tuple" at character 6

-- no such rule

drop instance rule nonesuch on noplace;

ERROR:parser: parse error at or near "instance" at character 6

ERROR:syntax error at or near "instance" at character 6

-- no such rule

drop rewrite rule nonesuch;

ERROR:parser: parse error at or near "rewrite" at character 6

ERROR:syntax error at or near "rewrite" at character 6

--

-- Check that division-by-zero is properly caught.

--

' - next line' /* this comment is not allowed here */

' - third line'

AS "Illegal comment within continuation";

ERROR:parser: parse error at or near "' - third line'" at character 75

ERROR:syntax error at or near "' - third line'" at character 75

--

-- test conversions between various string types

-- E021-10 implicit casting among the character data types

-- syntax errors

-- test for extraneous comma

CREATE TABLE error_tbl (i int DEFAULT (100, ));

ERROR:parser: parse error at or near "," at character 43

ERROR:syntax error at or near "," at character 43

-- this will fail because gram.y uses b_expr not a_expr for defaults,

-- to avoid a shift/reduce conflict that arises from NOT NULL being

-- part of the column definition syntax:

CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));

ERROR:parser: parse error at or near "IN" at character 43

ERROR:syntax error at or near "IN" at character 43

-- this should work, however:

CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));

DROP TABLE error_tbl;

ERROR: return type mismatch in function: declared to return integer, returns "unknown"

CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql

AS 'not even SQL';

ERROR:parser: parse error at or near "not" at character 1

ERROR:syntax error at or near "not" at character 1

CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql

AS 'SELECT 1, 2, 3;';

ERROR: function declared to return integer returns multiple columns in final SELECT