In a WHERE clause, I want to to compare strings ignoring the spaces
inside them. Is therd a function to do that? I do not find it in the
documentation.
SELECT ... WHERE (ignore_spaces(table.phone_number) ~* igore_spaces(?));

I have Visio for Visual Studio.NET Enterprise Architect 2003 and I am
designing a PostgresSQL database using it. Is it possible to generate and
manage a PostgresSQL database using Visio?

I've learned that one can't use temporary tables within the function unless
EXECUTE'd the SELECTS from that temp table.
So, I have a function like this:
CREATE FUNCTION Foo1(int4, int4) RETURNS SETOF myType