<div>
Still nothing. &nbsp;Does it matter how my username is stored in the users table? &nbsp;The weird thing is if I do<br />
SELECT user_id from users where username = 'cmuench' &nbsp;it returns with a 1.
</div>


Still nothing.  Does it matter how my username is stored in the users table?  The weird thing is if I do
SELECT user_id from users where username = 'cmuench'  it returns with a 1.

<div>
Got it to work. &nbsp;I thought I had removed the single quotes around the $1 but it hadn't the first time. &nbsp;I thne reopened the query and deleted them. &nbsp;Thanks for the suggestion. &nbsp;It was driving me crazy
</div>


Got it to work.  I thought I had removed the single quotes around the $1 but it hadn't the first time.  I thne reopened the query and deleted them.  Thanks for the suggestion.  It was driving me crazy

<div>
<div class="content wysiwyg-content">
I have the following function. &nbsp;I want to call it with a username and then it return a user_id for that user.<br />
CREATE OR REPLACE FUNCTION public.get_user_id (username char) RETURNS int4 AS<br />
$$ SELECT user_id from users where username = '$1' $$<br />
LANGUAGE 'sql'<br />
GO<br />
<br />
That doesn't work. &nbsp;when I execute the function.<br />
select public.get_user_id('cmuenc<wbr />h') as user_id &nbsp; I get NULL back. &nbsp;However when I just do a straight select with the username in the where clause it reuturns a 1 like its supposed to.
</div>
</div>


I have the following function.  I want to call it with a username and then it return a user_id for that user.
CREATE OR REPLACE FUNCTION public.get_user_id (username char) RETURNS int4 AS
$$ SELECT user_id from users where username = '$1' $$
LANGUAGE 'sql'
GO

That doesn't work.  when I execute the function.
select public.get_user_id('cmuench') as user_id   I get NULL back.  However when I just do a straight select with the username in the where clause it reuturns a 1 like its supposed to.

Postgresql function syntax help

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.